Edit

Integrate virtual tables with Power Pages

  • Article

A virtual table is a special type of table that doesn't have a physical representation in the Microsoft Dataverse but rather represents a query or view of the external data source. They enable the integration of external data source by seamlessly representing data as a table without data replication.

Note

This article explains how to create virtual tables in Dataverse manually, and then, them in Power Pages. You can also create virtual tables directly from the Data workspace in the design studio. More information: Create and modify virtual tables by using the Data workspace (preview)

Steps to integrate virtual tables in Power Pages

Using a virtual table in Power Pages follows a similar process to creating tables in Data workspace and using Dataverse views and forms to create web page list and form components.

  1. Create a virtual table in Dataverse

  2. Set up virtual table relationships

  3. Configure a web page with components using a virtual table

Create a virtual table in Dataverse

There are various ways to create a virtual table in Dataverse. Currently, Power Pages support virtual tables created using the providers listed below.

Finance and operations virtual tables

Dynamics 365 Finance and Operations is a business application that is designed to help organizations manage their financial, operations, and supply chain. Finance and operations apps are a virtual data source in Dataverse, and enable full create, read, update, and delete (CRUD) operations from Dataverse. Learn how to surface finance and operations virtual tables in Power Pages.

Virtual connector providers

Virtual connectors are built using Power Platform Connectors, which are pre-built connectors that provide a way to interact with external systems. Virtual connectors streamline creation experience by automating some of the creation and removing the need to use code to create the virtual tables.

To learn how to create virtual table in Dataverse, go to create a virtual table using virtual connector.

Custom virtual table data providers

Using Microsoft Dataverse Data SDK, .NET Developers have the option of creating custom virtual table data providers to help integrate external data source types that are not supported by an existing data provider. Each data provider is composed of a reusable set of Dataverse plug-ins that implement the supported CRUD operations.

Note

  • Power Pages requires that all tables have an ID attribute, this ID is known as a unique identifier and the value must be a guid.
  • While retrieving the virtual table from external data source in plugin, explicitly set AllColumns attribute to true.

To learn how to create virtual table using custom data provider in Dataverse, go to Custom virtual table data providers.

Business Central virtual tables

Dynamics 365 Business Central is a complete enterprise resource planning (ERP) software solution for mid-sized organizations. Business Central Virtual tables enables create, read, update, delete (CRUD) operations from Microsoft Dataverse. More information: Business Central virtual tables with Power Pages

Set up virtual table relationship

Setting up a table relationship to a contact or account table is an optional step if you're configuring virtual table permission for Global type access. Account and contact access types provides limited access to table records for the website user. Learn more about securing the data using table permissions.

To configure the account and contact scope, you need to create a many-to-one relationship with virtual table to account and contact table respectively. To learn more about virtual table relationships, go to Setting up a virtual table relationship.

Configure web page using virtual table

Once the virtual table is created in Dataverse, you can use to create a list, form, and multistep form components using the same process as using a standard Dataverse table.

Unsupported virtual tables and providers

The following virtual tables and providers are not supported for use with Power Pages;

Limitations

Dataverse virtual tables have a set of limitations that also apply when using in Power Pages, For more details go to Limitations and troubleshooting virtual tables.

See also

Create and modify virtual tables by using the Data workspace (preview)