'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Access Denied When Importing SharePoint Excel Query to Power BI
Question details
The user is experiencing an Access Denied error when attempting to import an Excel query hosted on SharePoint or OneDrive into Power BI.
- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Connecting Power BI to an Excel dataset stored on SharePoint or OneDrive to establish a stable cloud-based data connection.
- Observed behavior
- Power BI returns an Access Denied error, preventing the software from successfully importing or refreshing the Excel query from the SharePoint source.
Ensure you have the exact SharePoint or OneDrive file path URL and verify that your Microsoft 365 account has at least read-level permissions for that specific SharePoint site or file.
Clear and Reconfigure Data Source Permissions in Power BI
Clearing existing cached credentials in Power BI is the most effective fix for SharePoint authentication and access denied errors.
Power BI often caches older or incorrect credentials (such as an expired token or anonymous login). Forcing Power BI to forget these credentials allows you to sign in fresh using the correct Organizational Account.
Launch Power BI Desktop, click on the 'File' tab in the top ribbon, select 'Options and settings', and then click on 'Data source settings'.
In the Data source settings window, locate the SharePoint or OneDrive URL in the list. Right-click the URL and select 'Clear Permissions' to remove the cached login details.
Attempt to get data from the SharePoint URL again. When prompted for credentials, ensure you select the 'Organizational account' tab (not Windows or Anonymous) and sign in with your Microsoft 365 credentials.
Verify the Exact SharePoint File Path and Connector
Using an incorrect URL format or the wrong connector type can lead to immediate access denial.
Consult the Power BI Community Forum
If standard permission resets fail, the issue may require specialized diagnosis of your tenant's Power BI and SharePoint integration settings.
Edit and Manage Excel Data Easily with WPS Office
While troubleshooting complex Power BI and SharePoint connectivity issues, you might need a reliable, lightweight alternative for viewing, editing, and managing your Excel datasets locally. WPS Office provides a seamless spreadsheet experience without heavy resource requirements.
- 1. Download the Software: Visit the official WPS Office website and download the free installer for your specific operating system.
- 2. Install WPS Office: Run the downloaded setup file and follow the straightforward on-screen instructions to complete the installation.
- 3. Manage Your Datasets: Launch WPS Spreadsheet to open, review, and perfectly format your .xlsx or .csv files before building data models in external dashboards.
Frequently Asked Questions
Why does Power BI say Access Denied when I have full SharePoint permissions?
This usually happens because Power BI Desktop is holding onto old, cached credentials (such as an expired token or a Windows login) rather than actively using your current organizational account to authenticate with SharePoint.
Which Power BI connector is best for a single SharePoint Excel file?
If you are connecting to a single Excel file hosted on SharePoint, it is generally recommended to use the 'Web' connector and paste the file's direct path. If you are importing multiple files from a directory, use the 'SharePoint Folder' connector instead.
Can I connect Power BI to a local Excel file instead to avoid this error?
Yes, you can use the 'Excel Workbook' connector in Power BI to import a file stored on your local hard drive. However, relying on a local file means the Power BI service will not be able to automatically refresh the data in the cloud unless you set up and configure a personal data gateway.
