Connect to external data from Dataverse
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||Dec 4, 2022||-||Jan 2023|
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.
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.
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.