Integrating with Microsoft Dataverse

Path: Integration > Integrating with Microsoft Dataverse · tier official · system integration · narrative reviewed (checked by Opus)

Overview

Integrating Business Central with Microsoft Dataverse connects Business Central to Dynamics 365 applications and custom apps built on Dataverse. The landing page lists the main mechanisms: data synchronization, virtual tables, data change events, webhooks, and business events.

The section has two subtopics. Data synchronization (15 pages) covers bidirectional sync setup, customizing integration tables, field and option mappings, coupling records, and generating AL proxy tables. It also includes a Dataverse API subtopic. Data virtualization (6 pages) covers Business Central virtual tables in Dataverse: how they expose data to Power Platform, how to model and relate them, how to manage them as solutions (ALM), and common FAQs.

Start with the landing page to pick the approach. Then go to data synchronization if you need to copy and keep data in step, or to data virtualization if you want Dataverse and Power Platform to read Business Central data through virtual tables.

Key points

• Integration options named on the landing page: data synchronization, virtual tables, data change events, webhooks, and business events.
• Data synchronization supports setting up bidirectional sync between Business Central and Dataverse.
• Sync can be customized through integration tables, field mappings, and option mappings.
• Records can be coupled between the two systems, and AL proxy tables can be generated.
• The data synchronization subtopic also includes a Dataverse API subtopic.
• Data virtualization uses Business Central virtual tables in Dataverse to expose data to Power Platform.
• Virtual tables can be modeled, related to other tables, and managed as solutions (ALM).
• The data virtualization pages include FAQs.

Subtopics

• Data synchronization (15 pages)
• Data virtualization (6 pages)

More Learn pages

• Integrating with Microsoft Dataverse: Learn how to integrate Business Central with Microsoft Dataverse

Videos, posts and code changes

Linked by a Haiku matcher with a grounding quote from the item’s summary (link/topics.ts); machine-generated.

• #10207 [Dataverse] Use Truncate for CRM Integration Record cleanup during environment copy (code change): “Environment copy cleanup of CRM Integration Records now uses bulk truncate”
• #10578 [Extensibility Request] issue 30429: add events to disambiguate CRM integration table mappings (code change): “Four integration events are added to allow extensions to select the correct CRM integration table mapping”
• #10753 Cross-environment Master Data synchronization (same tenant) (code change): “Cross-environment Master Data Management now allows subsidiary environments to synchronize master data”
• #11626 [Master Data Management] Fixing synchronization of contacts, media, date, datetime, source watermarking, permission issue and minor UX issues (code change): “Master Data Management synchronization is fixed to handle contacts”
• #12196 [Master Data Management] Disable cross-env setup action OnPrem and fix field visibility issues (code change): “Master Data Management cross-environment setup action is now disabled”
• #9127 Add Dataverse Cloud endpoints override for sovereign clouds (code change): “A new interface and enum enable partners to override Dataverse endpoints for sovereign cloud environments”
• #9322 [FS Integration] SVCITEM-CUSTASSET mapping ignores “Convert to Customer Asset” flag — every Service Item synced to FS unconditionally (code change): “Field Service Integration now respects the Dataverse Product setting Convert to Customer Asset”
• What’s New: Business Central Integration with Dataverse (2024 release wave 1) (video): “dataverse integration; data synchronization; virtual tables; data change events”
• What’s New: Using Power Pages with Business Central (2024 release wave 1) (video): “power pages; virtual tables; multi-company support; dataverse”
• What’s New: Dataverse & Dynamics 365 App Integration (2023 release wave 2) Part 1 (video): “Multi-company and multi-environment synchronization; virtual tables visibility”
• What’s New: Auto-Applying Templates in Integration with Dataverse (2024 release wave 2) (video): “Auto-Applying Templates in Integration with Dataverse; configuration templates; data synchronization”
• What’s New: Dataverse & Dynamics 365 App Integration (2023 release wave 2) Part 2 (video): “Dataverse integration; virtual tables; power pages; data synchronization; business events”

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 7214 “CDS Companies” · captioned “Dataverse Companies” · on Table 5393 “CDS Company” · via Data synchronization

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.