Permission & Access Issues

Fix Power BI Access to an Excel File in SharePoint

Jason MillerJason Miller Nov 13, 2026 869 views

Question details

The user needs Power BI to connect to an Excel workbook stored in a Teams-connected SharePoint site without receiving an access-forbidden error.

Fix Power BI Access to an Excel File in SharePoint
Product
Microsoft Power BI Desktop, Microsoft Excel, and SharePoint Online
Device & OS
not provided
Scenario
Importing workbook data from a SharePoint site connected to Microsoft Teams while signed in as a site owner.
Observed behavior
Power BI reports that access is forbidden despite site-owner status. Troubleshooting also produced blank Excel previews, rejected sharing links, and SharePoint Folder or Web connection errors; local copies of the workbooks worked.
Before you start

Open the workbook in SharePoint using the same organizational account you intend to use in Power BI, and confirm that you can read or download it. Copy the URL of the site that actually stores the workbook, rather than a file-sharing link or Teams link.

Solution 1Recommended

Connect through SharePoint Folder using the site URL

Use this connection method when a file URL or sharing link is rejected or produces an access error.

Site-owner status alone does not confirm that Power BI is connecting to the correct location with the correct account. The SharePoint Folder connector requires a site URL, not a direct workbook URL.

1
Locate the workbook's SharePoint site

In Teams, open the channel's Files area and select Open in SharePoint. Identify the site containing the workbook and copy its site URL, such as https://contoso.sharepoint.com/sites/Finance, without the document-library or filename portion.

2
Open the SharePoint Folder connector

In Power BI Desktop, select Home > Get Data > More, search for SharePoint Folder, and select Connect. Paste the site URL and continue.

3
Authenticate and select the workbook

When prompted, choose Organizational account and sign in with the account that can read the workbook. Select Transform Data, filter the file list by Name and Folder Path, and use the target workbook's Content value to access its tables or sheets.

Connect through SharePoint Folder using the site URL
Use the workbook's actual storage location: If the workbook is stored in a different SharePoint site, including a separate channel site, connect to that site's URL rather than assuming the parent team's site contains it.
Free Microsoft Office alternative

Review Downloaded Excel Workbooks with WPS Spreadsheet

WPS Office is a free, lightweight alternative for reviewing and editing downloaded Excel workbooks. Its familiar spreadsheet interface and Excel format compatibility make migration easy for everyday workbook tasks, but it does not resolve Power BI authentication or SharePoint access errors.

Open downloaded workbooks to inspect their sheets and source data.Supports Microsoft Excel .xlsx and .xls formats.Familiar spreadsheet tools make switching from Excel straightforward.A lightweight, free option for everyday Office file editing.
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power BI say access is forbidden when I am a SharePoint site owner?

Power BI may be using saved credentials for another account, an unsuitable authentication method, or the wrong URL. Confirm browser access with the intended account, then use Data Source Settings to clear the affected credentials and reconnect with Organizational account.

Which URL should I enter in the SharePoint Folder connector?

Enter the site's root URL, such as https://contoso.sharepoint.com/sites/Finance. Do not enter a workbook-sharing link or a URL ending in a filename. Locate the workbook after connecting by filtering Name and Folder Path.

Does clearing Power BI permissions remove my SharePoint access?

No. Clear Permissions in Power BI's Data Source Settings removes saved connection credentials, not SharePoint site membership or file permissions. You will need to authenticate again when reconnecting.

What does it mean if the workbook works after I download it?

A successful local import through Home > Get Data > Excel workbook suggests that Power BI can read the workbook. It does not prove that the online connection is authorized; check the SharePoint location, saved credentials, and organizational access restrictions.

Can WPS Office fix the Power BI connection error?

No. WPS Spreadsheet can open a downloaded Excel workbook for data review, but Power BI's SharePoint connection must be corrected in Power BI or through your organization's Microsoft administrators.