Fix power bi datasource.errors with these steps

by Tashreef Shareef
Tashreef Shareef
Tashreef Shareef
Windows & Software Expert
Tashreef Shareef is a software developer turned tech writer. He discovered his interest in technology after reading a tech magazine accidentally. Now he writes about everything tech from... read more
Affiliate Disclosure
Power Bi data source.error access denied
To fix various PC problems, we recommend DriverFix: This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:
  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

Some times while trying to access data from excel, sqlserver, and oracle to general visuals you may encounter Power bi datasource.errors. These errors can have multiple messages depending on the user’s situation. The two most common error messages are ” power bi data source.error access denied and power bi datasource.error web.contents failed to get contents from” as reported by the users in the Power Bi community forums.

Hi For Data Refresh, I installed PowerBI Personal and On Premises Gateway, for configuring Gateway when i am opeing Pwersonal BI Gateway it is showing “Access Denied Error” and is not allowing me to proceed.
Any Idea?

If you are also troubled by this error, here are a couple of troubleshooting tips you can try to resolve the error.

Fix Power Bi datasource.errors

1. Power Bi data source.error access denied

Power Bi data source.error access denied
Check for Power Bi Update

  1. If you haven’t already tried, check the current version of your Power Bi desktop app. Check if a new version of the app is available for download.
  2. Download and install the app if available. After installing the update check if the issue occurs again. Power Bi supposedly has released an update to fix the issue.

Create New Pbix File and Clear Permission

  1. If the issue exists even after updating the Power Bi app, you may need to create a new Pbix file.
  2. So, start with creating a new Pbix file. After that clear the Permission data source of SharePoint that you have used before.
  3. To clear Permission data source, go to Edit > Queries.
  4. Select Data Source Settings > Global Permissions.
  5. Now find the Sharepoint source and click on Clear Permissions.
  6. Relaunch Power Bi Dekstop app and check if the issue is resolved.

Reinstall Power Bi Desktop

  1. If the issue persists, as a last resort you can try reinstalling Power Bi desktop to resolve the issue. Reinstalling the app has helped several users to resolve the error.
  2. Press Windows Key + R to open Run.
  3. Type control and click OK to open the Control Panel.
  4. In the Control Panel, go to Programs > Programs and Features.
  5. Select Power Bi Desktop app and click on Uninstall.
  6. Reboot the systems.
  7. Now download the latest version of Power Bi Dekstop from the official website.
  8. Install the app and check if the datasource.errors access denied still occurs.

You can disable See Records in Power BI in 2 easy steps

2. Power Bi datasource.error web.contents failed to get contents from
Power Bi datasource.error web.contents failed to get contents from

Disable Parallel Query Processing 

  1. If you have Parallel Query Processing enabled, you may want to disable it for time being to resolve the datasources.error.
  2. Many users have reported that disabling Parallel Query Processing has resolved the issue for them.

Check for Additional Rows

  1. If there are additional rows under your filtered files, try removing these error record to resolve the error.
  2. First, click on Remove Rows and then Remove error. If not, click on Remove Rows and then click on Remove the last row from below.
  3. Now try to follow the steps you want to apply on your data sheet.


Still having issues? Fix them with this tool:


Some driver-related issues can be solved faster by using a dedicated tool. If you're still having problems with your drivers, just download DriverFix and get it up and running in a few clicks. After that, let it take over and fix all of your errors in no time!

This article covers:Topics: