Create virtual tables to use external data sources


Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview General availability
Users, automatically Oct 2023 Dec 2023

Business value

The feature allows you to connect your Power Pages site to external data sources, such as SQL Server and Microsoft SharePoint, from the Data workspace in Power Pages studio.

Feature details

You can create Virtual Tables using the following SQL Server and Microsoft SharePoint virtual connector providers inside the Power Pages studio Data workspace. Virtual tables enable data integration from external data sources by representing that data as tables in Microsoft Dataverse without data replication. Solutions, apps, flows, and more can use virtual tables as if they were native Dataverse tables. Virtual tables allow for full create, read, update, and delete privileges unless the data source they're connecting to specifically forbids it.