Virtual tables creation wizard now in Public Preview
Image Source: Shutterstock.com
Jan 11, 2023 9:30 PM

Virtual tables creation wizard now in Public Preview

External Blog Post

Have you tried creating a virtual table and found it difficult? Do you wish you had an way to integrate external data from SharePoint and SQL into Dataverse

We are excited to announce that makers can now create virtual tables directly in the maker portal in just a few minutes using a guided…

  • Create virtual tables from SharePoint and SQL without coding, from the maker Portal.
  • Simply set up your connection, pick your SharePoint Site or SQL Database, select your SharePoint List or SQL Table to create a virtual table.
  • What are the benefits of virtual tables?
  • How can I start using the new virtual tables wizard?

Open full article

Create virtual tables using the virtual connector provider (preview)

Virtual tables enable integrating data from external data sources by seamlessly representing that data as tables in Microsoft Dataverse, without data replication. Solutions, apps, flows, and more can use virtual tables as if they were native Dataverse tables

https://learn.microsoft.com/en-gb/power-apps/maker/data-platform/create-virtual-tables-using-connectors?tabs=sql&WT.mc_id=M365-MVP-5004644

Read more about virtual tables and virtual connector providers here:

Create virtual tables using connectors

Known limitations and troubleshooting with virtual tables

Setting up relationships with virtual tables with Power Apps

Or refer to these videos:

Virtual tables overview: https://youtu.be/weyEDIKhi18

Create virtual tables: https://youtu.be/ttw4bF1mT3g

Integrate virtual tables with Dataverse: https://youtu.be/gjum546ycpg