Connect to external data from Dataverse

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

Enabled for Public preview Early access General availability
Admins, makers, marketers, or analysts, automatically Oct 2022 - Jan 2023

Business value

Connect existing data sources, such as SQL Server, Excel file, or Microsoft List with Microsoft Dataverse and interact with that external data as if it's part of Dataverse.

Feature details

Microsoft Dataverse has supported virtual tables for a long time. They're extremely powerful but can be difficult to set up. With this release, you'll be able to create tables in Dataverse that surface external data by leveraging simple connections to find the external data. For example, a Dataverse table with data from an Excel workbook in OneDrive or a SQL Server in Azure.

Screen of creating a table using a tabular connector.

Depending on the connection, a table will be automatically generated with the correct schema and integration. You can do all this through a simple wizard in Power Apps, which gives you as much control as you need over configuring the details while creating the Dataverse table.