Others

Fix Power Apps Showing Azure SQL Columns but No Data

Kushani Nimanthika Sep 27, 2026 869 views

Question details

Power Apps displays the schema (table and column names) of an Azure SQL database but fails to load the actual data records in the app.

How to Fix Power Apps Showing SQL Columns but No Data

Product: Power Apps
Device & OS: not provided
Scenario: Connecting a Power Apps application to an Azure SQL database to view, filter, or manage data within galleries or data tables.
Observed behavior: The application successfully connects to the database and loads the table structures and column headers, but the galleries remain entirely blank and return no row values.

Before you start

Ensure that your target Azure SQL database actually contains data rows and that your network environment allows outbound connections to Azure services.

Solution 1Recommended

Verify SQL Connection and Table Permissions

Ensure that your Power Apps connection to Azure SQL is properly authenticated and has the correct read access permissions.

Often, Power Apps can read the metadata (schema) of a database, but the specific user account used in the connection lacks the required SELECT permissions to read the rows, or a firewall is blocking the data retrieval.

Check database firewall settings

Go to your Azure portal, navigate to your SQL server's networking settings, and ensure 'Allow Azure services and resources to access this server' is enabled.

Verify user permissions

Ensure the SQL user account specified in your Power Apps connection string has explicit 'SELECT' permissions granted for the tables you are trying to query.

Refresh the data source

Open your application in Power Apps Studio, navigate to the 'Data' tab on the left sidebar, click the three dots next to your Azure SQL connection, and select 'Refresh'.

Verify SQL Connection and Table Permissions

Primary Keys Required: Power Apps requires SQL tables to have a Primary Key defined to properly read and update records. Ensure your SQL table has a valid Primary Key.

Solution 2

Troubleshoot Delegation and Gateway Configuration

Resolve issues where datasets fail to load due to delegation limits or misconfigured local data gateways.

Solution 3

Consult the Microsoft Power Platform Community

Since advanced data connections can involve complex enterprise architectures, specialized technical support may be required to diagnose the issue.

Free Microsoft Office alternative

Looking for a Reliable Office Suite? Try WPS Office

While troubleshooting advanced database connections in Power Apps, you might also need a fast and efficient tool for managing exported SQL datasets, reports, and documentation. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office.

1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded file and follow the simple on-screen instructions to complete the installation.
3. Manage your data: Open WPS Spreadsheet to view, analyze, and format any CSV or Excel files exported from your databases.

Free and lightweight comprehensive Office suiteFully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsBuilt-in robust data analysis tools for handling exported database recordsFamiliar user interface ensuring seamless migration with zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Apps show SQL column names but no actual data?

This usually happens when the connection successfully reads the database schema (metadata), but the authenticated user lacks 'SELECT' permissions to view the actual rows, a firewall blocks the data payload, or the table is missing a Primary Key.

How do I know if delegation is causing my empty gallery?

Look at the formula bar for your gallery's 'Items' property. If you see a yellow warning icon or a blue underline, Power Apps is warning you that the query cannot be delegated to SQL. If the dataset exceeds the delegation limit (default 500 rows), no data might be returned.

Does my Azure SQL database need specific firewall rules for Power Apps?

Yes. If your Power App is connecting directly from the cloud, your Azure SQL database must have the 'Allow Azure services and resources to access this server' setting enabled in its networking/firewall configuration.

Office Quick Solutions