Hello Everyone,
Today I am going to share my experience with virtual tables which can be connected from SQL or Sharepoint to create a virtual table.
Lets gets started.
What is Virtual Table?
Virtual table is an intersect table between two different systems, i.e replica of the data source table(SQL or Sharepoint) in Dataverse.
Previously if you want to connect to external data source, you are supposed to integrate the two systems, like sharepoint or SQL Server data source into the Dataverse.
Now no more coding required to integrate the data source into Dataverse from SQL or Sharepoint, Many thanks to Microsoft.
Note: When a virtual table is created inside the Dataverse from SQL or Sharepoint, the data stored in Dataverse virtual table is not considered towards Dataverse storage even millions of records exists in SQL or Sharepoint.
You can make relationship between virtual table and dataverse tables no issues at all.
Lets see how to create virtual table.
Login into Make.Powerapps.com
Create a…
Source link
More About This Author
Array
- Dyn365CE5 October 2023{How to} Get Latest Portal Solution Metadata Translations on Power Pages
- Dyn365CE4 October 2023{How to} Set Power Pages Site Actions
- Dyn365CE3 October 2023{How to} discover makers working on the Power Pages Site with Copresence
- Dyn365CE2 October 2023Release Plans for Dynamics 365, Power Platform, Microsoft Cloud of Industry