Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
1 like 0 dislike
4.7k views
in Power BI by 35 44 53

In Power BI Desktop, I got this error Loading Blocked by Failures with other Queries when trying to refresh the data in Query editor, How can I solve this issue?

Loading blocked by failures with other queries Power BI


1 Answer

2 like 0 dislike
by 152 169 345
selected by
 
Best answer

Solving: Loading blocked by failures with other queries Power BI

When you face this issue Loading blocked by failures with other queries Power BI, that means you have an error on one or more queries in Power Query Editor such as:

  1. The Datasource settings have been changed.
  2. The Datasource Path has been removed or changed in case, you are using Excel or CSV file.
  3. The Datasource path is correct but it's too long.
  4. The file name is too long.
  5. One or more fields have been renamed or removed in your main data source.
  6. One of more steps has an error due to missing field names.
  7. The data type of one field or more has been changed.
  8. You're using outdated data connectors, so you have to update the Power BI Desktop to the latest version.

If you have recently updated the Power BI Desktop, and your data source path and fields have not been changed, so you just need to update the data source again.

In case, you have one of the above root causes, the Power Query will not allow refreshing the data, and you will get this error "Loading blocked by failures with other queries Power BI", and to solve this issue you have to do the following:

Steps

  1. Open your Dashboard using Power BI Desktop.
  2. Click on "Transform Data" > Data Source Settings to manage the settings for your data source.
  3. Ensure that the Data Source Path is correct, and is not long, and try to update it by clicking on "Change Source".
    Loading blocked by failures with other queries Power BI
  4. Go back and click on "Transform Data" to open the Power Query.
  5. Go through each query and Refresh it.
  6. Then go through each step and ensure that there is no error on the applied steps.
  7. If you have renamed a field name or its datatype in the main data source and you want to update it in your Power Query without affecting the Applied Steps, you have to use the Advanced Editor.

Read more at Power BI: Loading Blocked by Failures with other Queries

by 35 44 53
0 0
Thanks Mohamed, the reason 5 was the issue!
If you don’t ask, the answer is always NO!
...