Permission & Access Issues

Fix Power BI Cannot Load Excel File from SharePoint into Semantic Model

Maira Mehtab Sep 20, 2026 868 views

Question details

The user receives an error in the Power BI service when attempting to connect a new semantic model to an Excel file stored in a SharePoint folder.

Product: Power BI / SharePoint
Device & OS: not provided
Scenario: Creating a new semantic model in a Power BI workspace using an Excel file hosted on SharePoint.
Observed behavior: An error message appears during the connection process, preventing the Excel file from loading into the semantic model.

Before you start

Ensure that the Power BI service is currently online without outages and that you are logged in using the exact same Microsoft account for both Power BI and SharePoint.

Solution 1Recommended

Verify File Accessibility and SharePoint Permissions

Confirm that the file exists and that your account has the necessary permissions to read the file directly in SharePoint.

Often, connection errors arise because the user account attempting to build the semantic model does not have sufficient read permissions on the SharePoint site, or the file has been moved.

Test direct file access

Open a web browser, log into SharePoint with the account you use for Power BI, and navigate to the folder. Click on the Excel file to verify it opens successfully.

Verify account permissions

Right-click the Excel file in SharePoint, select 'Manage Access', and ensure your account is listed with at least 'View' or 'Read' permissions.

Check workspace access

In the Power BI service, go to your workspace, click 'Manage access', and confirm you have 'Member' or 'Admin' rights to create and configure semantic models.

Authentication Type: When setting up the data source credentials in Power BI, make sure to select 'OAuth2' for SharePoint connections.

Solution 2

Verify the File Path and Workbook Compatibility

Ensure you are using the correct SharePoint URL and that the Excel file is in a supported format.

Solution 3

Consult the Power BI Community Forums

Gather exact error details and reach out to Microsoft's specialized Power BI community for advanced diagnostic help.

Free Microsoft Office alternative

Prepare Your Excel Data Easily with WPS Office

While Power BI and SharePoint are Microsoft ecosystems, you can use WPS Office to prepare, clean, and format your spreadsheet data locally before uploading. It's lightweight, fully compatible with Microsoft Excel formats, and completely free to use.

1. Download and Install: Download WPS Office for free from the official website and follow the installation wizard.
2. Open Your Data: Launch WPS Spreadsheets and open your local .xlsx files seamlessly without any formatting loss.
3. Clean and Save: Clean your dataset, format your tables, and save the file. You can then upload this optimized file to SharePoint for Power BI usage.

100% compatible with Microsoft Excel (.xlsx) formatsLightweight and fast for handling large datasetsFree to use with a highly familiar spreadsheet interfaceBuilt-in data cleaning and formatting tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power BI say it cannot find my SharePoint Excel file?

This usually happens if the file path is incorrect (often due to trailing query parameters like '?web=1'), the file was moved or deleted, or your Power BI account lacks permission to view the specific SharePoint site.

Can I use a personal OneDrive file instead of SharePoint for Power BI?

Yes, Power BI supports connecting to Excel files hosted on both OneDrive for Business and personal OneDrive accounts, provided you authenticate the data source with the correct Microsoft credentials.

What Excel workbook formats are supported as semantic models in Power BI?

Power BI primarily supports .xlsx, .xlsm, and .csv formats. If your file is saved in the legacy .xls format, you will need to open it and save it as an .xlsx file before connecting it to Power BI.

How do I fix authentication errors when connecting SharePoint to Power BI?

Go to the semantic model settings in the Power BI service, find 'Data source credentials', click 'Edit credentials', and ensure the authentication method is set to 'OAuth2' with the Privacy Level set appropriately (usually 'Organizational').

Document & File Issues