Virtual tables

Important

This content is archived and is not being updated. For the latest documentation, go to What is Microsoft Dataverse?. For the latest release plans, go to Dynamics 365 and Microsoft Power Platform release plans.

Important

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

Virtual tables allow Microsoft Dataverse to surface data stored outside of the Dataverse relational storage for use in Power Platform. Data accessed through a virtual table looks and acts like a native Dataverse table. For example, your SQL Server data can be accessed through Dataverse tables, using Dataverse APIs and plugins and can have relationships to your native Dataverse tables like accounts, contacts, or other custom tables you create.

Virtual tables can be used to connect to tabular data (SQL, Excel, SharePoint), non-tabular data (data lake, Azure Cosmos DB, SAP), data accessed through direct OData calls, or custom connections that users can craft to meet their needs.