Others

How to Use Excel and SQL Data Sources in Power Pages

Guest Writer Oct 12, 2026 869 views

Question details

The user needs to configure Power Pages to interact with non-Dataverse data sources, such as Excel, SharePoint, and SQL databases.

How to Connect Power Pages to Excel and SQL Data Sources

Product: Microsoft Power Pages
Device & OS: not provided
Scenario: Integrating and displaying external data from Excel, SharePoint, or SQL directly within a Power Pages site.
Observed behavior: The user must configure virtual connection providers for standard integrations or develop custom data providers and plug-ins to enable full CRUD operations for SQL virtual tables.

Before you start

Ensure you have System Administrator access to your Power Platform environment and have downloaded the Plugin Registration Tool if you plan to configure custom SQL virtual tables.

Solution 1Recommended

Use Virtual Connection Providers for Excel and SharePoint

This is the simplest method for integrating external file-based data sources like Excel workbooks or SharePoint lists into your Power Pages site.

Power Pages can seamlessly display data from Excel and SharePoint by utilizing Microsoft's native virtual connection providers. This allows the data to remain in its original location while being accessible within your portal.

Access the Maker Portal

Create a Virtual Table

Navigate to the Dataverse tables section, choose to create a new table, and select 'Create from external data'. Choose the Virtual Connector Provider.

Select the Data Source

Choose Excel Online or SharePoint from the connection list, authenticate your credentials, and select the specific file or list you want to use as your data source.

Use Virtual Connection Providers for Excel and SharePoint

Connection Limitations: Ensure your Excel file is formatted with designated tables, as the virtual connection provider requires structured tables to read the rows and columns properly.

Solution 2

Configure SQL Virtual Tables for CRUD Operations

Use this method when you need to connect to a SQL database and perform Create, Read, Update, and Delete (CRUD) operations from your Power Pages site.

Free Microsoft Office alternative

Prepare Your Excel Data Sources Easily with WPS Office

Before connecting your spreadsheets to Power Pages, you can use WPS Office to clean, structure, and format your Excel data. It is a highly compatible, fast, and free alternative to Microsoft Office that makes managing large datasets effortless.

1. Open Your Dataset: Launch WPS Spreadsheet and open the raw data file you intend to use for your Power Pages site.
2. Format as a Table: Clean your data, remove empty rows, and use the 'Format as Table' feature so the virtual connection provider can accurately map the columns.
3. Save and Upload: Save the document in standard .xlsx format, then upload it to your SharePoint or OneDrive to finalize the Power Pages connection.

Seamless compatibility with Microsoft Excel (.xlsx) filesRich data formatting and structuring tools to prep data for Power PagesLightweight application that runs smoothly even on older PCsFree to use with a familiar interface and zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can standard Excel virtual tables support full CRUD operations in Power Pages?

Standard virtual tables for Excel are primarily optimized for read operations. Full Create, Update, and Delete operations are best handled through Dataverse natively or via custom SQL data providers.

What permissions are required to set up a custom data provider for SQL?

You must have System Administrator privileges in your Power Platform environment to register custom plug-ins using the Plugin Registration Tool.

Why is my Excel file not recognized by the virtual connection provider?

The virtual connection provider requires the data inside your Excel workbook to be explicitly formatted as a Table (using the 'Format as Table' option). It cannot read raw, unstructured worksheet cells.

Office Quick Solutions