This post is part of the New Functionality In Microsoft Dynamics 365 Business Central 2024 Wave 1 series in which I am taking a look at the new functionality introduced in Microsoft Dynamics 365 Business Central 2024 Wave 1.
The 2nd of the new functionality in the Adapt faster with Power Platform section is use virtual tables to expose more Business Central data in Dataverse.
Use virtual tables when you synchronize data between Business Central, Dataverse, and other Dynamics 365 apps to enhance the value of your Dynamics 365 investment. Virtual tables erase boundaries between Dynamics 365 apps and make your data accessible to users in their preferred app.
Enabled for: Users by admins, makers, or analysts
Public Preview: Mar 2024
General Availability: Apr 2024
When you synchronize data between Business Central and Dataverse, you can add a synthetic relationship between a synchronized entity and a virtual table if you enable virtual tables in Business Central. Virtual tables let you enrich the data you’ve set up to synchronize from Business Central with data you haven’t, without help from a developer.
On the surface this sounds useful, but I really need to take a look at how this feature works. It would be useful to access additional data with Power Automate, but I need to see how easy it is to expose tables and also how easy it is to replicate that between environments.