Virtual table

A Dataverse table whose data is sourced from an external system at query time rather than stored in Dataverse.

A virtual table in Microsoft Dataverse is a table whose data is not stored in Dataverse but is fetched from an external system on demand. To Power Apps, Power Automate, Copilot Studio, and Dynamics 365 CRM apps, the virtual table looks like any other table — same query semantics, same forms and views, same relationships — but reads (and sometimes writes) go to the configured external source. Common use cases: surfacing Dynamics 365 Finance / Supply Chain data inside CRM-side apps without replicating; pulling SQL Server or SharePoint data into Power Apps; exposing custom APIs through OData adapters. Virtual tables avoid replication and stay current, but performance is bounded by the source system's responsiveness and API throughput.