This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2023 Wave 2.
The twelfth of the new functionality in the Adapt faster with Power Platform section is Relate native and virtual tables to expose more Business Central data in Dataverse.
Virtual tables and the data synchronization way of integrating Business Central to Dataverse and Dynamics 365 apps enhance the value of your Dynamics 365 investment by erasing boundaries between Dynamics 365 apps and making your data accessible to users in their preferred app.
Enabled for: Users by admins, makers, or analysts
Public Preview: Oct 2023
General Availability: Nov 2023
You can now create a relationship between native and virtual tables in Business Central. When you synchronize data between Business Central and Dataverse, data is transferred between the tables. Adding a relationship between a synchronized entity and a virtual table enables you to enrich the data coming from Business Central without help from a developer.
Not an area I’ve done anything with, but like a number of the other changes in the Adapt faster with Power Platform area of new features, I can see that this could be useful.