Virtual tables enable integrating data from external data sources by seamlessly representing that data as tables in Microsoft Dataverse, without data replication. Solutions built on Microsoft Power Platform can leverage virtual tables as if they were native Dataverse tables.
A virtual table is a custom table in Microsoft Dataverse that has columns containing data from an external data source. Virtual tables appear in your app to users as regular table rows, but contain data that is sourced from an external database, such as an Azure SQL Database, SharePoint, etc. Rows based on virtual tables are available in all clients including custom clients developed using the Dataverse web services.
In the previous blog, we learn about the installation of a Virtual Connector Provider to the Dataverse Environment in Power Platform.
In the previous blog, we learn about the connection for Share Point and Connection reference.
In this blog will learn the creation of the data source for the Virtual Tables in Dataverse
Creation Of the Data Source
- Go to Microsoft Power Apps maker Portal.
- Select the Dataverse Environment.
- Click on the Gear Icon and Select the Advanced Settings.
4. Navigate to Settings and Click on Administration.
5. Select Virtual Entity Data Sources.
6. Select New.
7. In the pop-up dialog, select the Virtual Connector Data Provider and Click Ok.
8. Name your Data Source and select the Connection Reference you created in the drop-down list.
- SQL Server
- Leave the Dataset Value field empty
- Microsoft Excel Online (Business)
- Paste in the file name including the extension into the Dataset Value. Remember the file must be in the OneDrive that was used for the Connection setup. (for example SampleData.xlsx)
- Microsoft SharePoint
- Paste the URL to your SharePoint site in the Dataset Value field (ex: https://contosoenvname.sharepoint.com/sites/sitename)
9. Click On Save.
Hope you learn something, Thanks for Reading 📖!