Others

Fix Power Apps Error: Tables Didn't Load Correctly from Personal OneDrive

Maira Mehtab Sep 20, 2026 869 views

Question details

The user is attempting to connect Power Apps to an Excel workbook in a personal OneDrive account but receives an error stating the tables failed to load, even though the file works perfectly on the desktop.

Product: Power Apps and Excel
Device & OS: not provided
Scenario: Importing or connecting an Excel workbook stored in a personal OneDrive account as a data source in Power Apps.
Observed behavior: Power Apps displays a 'The tables didn't load correctly' error and fails to connect to the data, while the same Excel workbook opens without any issues on a local desktop application.

Before you start

Verify that your Excel data is properly formatted as an official Excel Table (Insert > Table), as Power Apps cannot read standard ranges of data.

Solution 1Recommended

Recreate the OneDrive Connection in Power Apps

Deleting and recreating the connection can resolve temporary authentication glitches or syncing issues between Power Apps and personal OneDrive.

Remove the existing connection

Navigate to the Data section in your Power Apps environment, locate your current personal OneDrive connection, and delete it.

Add a new connection

Click on 'Add data', search for OneDrive, and select the personal OneDrive connector to authenticate your account again.

Re-link the workbook

Once the connection is established, select your Excel workbook from OneDrive and attempt to load the tables into your app.

Solution 2

Verify Workbook Integrity Locally

Downloading the file ensures that the workbook itself is not corrupted and that the issue is isolated strictly to the Power Apps connector.

Solution 3

Migrate to OneDrive for Business

Power Apps connectors are optimized for enterprise environments and work significantly more reliably with OneDrive for Business or SharePoint.

Free Microsoft Office alternative

Manage and Edit Your Spreadsheets Seamlessly with WPS Office

While Power Apps connection errors often stem from Microsoft's cloud environment limitations, you need a reliable tool to manage your underlying data. WPS Office is a highly compatible, free alternative for viewing, formatting, and modifying Excel workbooks locally without dealing with complex cloud-dependency errors.

1. Download and install: Get WPS Office for free from the official website and install it on your computer.
2. Open your workbook: Launch WPS Spreadsheet and open your downloaded .xlsx file to ensure your data is perfectly intact.
3. Edit effortlessly: Format your tables, adjust data ranges, and save your workbook with full Microsoft Office compatibility.

Fully compatible with Microsoft Excel (.xlsx, .xls) table formats.Lightweight and completely free to use for personal and professional tasks.Familiar, easy-to-use interface that requires no learning curve.Built-in local and cloud storage management to keep your files secure and accessible.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Apps work with SharePoint but fail with my personal OneDrive?

Power Apps is designed primarily for enterprise environments like SharePoint and OneDrive for Business. Personal OneDrive connectors sometimes lack the appropriate background environment configurations or permissions required for stable data syncing, leading to table loading errors.

Can a corrupted Excel file cause the 'tables didn't load correctly' error?

Yes. If the Excel file is corrupted, encrypted with a password, or formatted incorrectly, Power Apps will fail to read its tables. Downloading the file and opening it on a local desktop application is the best way to rule out file corruption.

Are there specific formatting rules for Excel tables in Power Apps?

Yes. For Power Apps to read Excel data, the specific data range must be explicitly formatted as an Excel Table (using the Insert > Table feature). Standard data ranges or sheets without defined tables will not be recognized by the connector.

What should I do if the file works locally but still fails in Power Apps?

If the file works perfectly on your desktop but fails to load from personal OneDrive, you are likely hitting a connector limitation. It is recommended to move the file to a business cloud storage solution (like OneDrive for Business) or reach out to Microsoft Learn support for environment-specific troubleshooting.