Fix power bi datasource.errors with these steps

3 minute read
Power Bi data source.error access denied

Home » Fix » Fix power bi datasource.errors with these steps

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.

RELATED STORIES YOU MAY LIKE:

Discussions

Next up

Google Chrome doesn’t finish downloads? Try this

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

We all know how good Google Chrome is. This is why the browser became the most popular surfing tool in the world. Usually, Chrome is […]

Continue Reading

Not enough physical memory error in VMware [FULL FIX]

Rabia Noureen avatar. By: Rabia Noureen
2 minute read

A large number of VMware users have reported encountering the following error message: Not enough physical memory is available to power this virtual machine with […]

Continue Reading

Troubles with your Uplay login? Here’s what you can do

John Taylor avatar. By: John Taylor
2 minute read

Some users have reported that they are having problems when trying to log in their Uplay client. Apparently, they receive an error message that looks […]

Continue Reading