Create virtual tables to use external data sources
Important
This content is archived and is not being updated. For the latest documentation, go to the Microsoft Power Pages documentation. For the latest release plans, go to Dynamics 365, Power Platform, and Cloud for Industry release plans.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users, automatically | 
Oct 2, 2023 |
Apr 2, 2024 |
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.
See also
Create and modify virtual tables by using the Data workspace (docs)