- 1 Why do you get Loading blocked by failures with other queries in Power BI?
- 2 Solving: Loading blocked by failures with other queries Power BI
In Power BI, while refreshing the data or when the Power BI Schedule tries to run, you may get this error “Loading Blocked by Failures with other Queries“.
Why do you get Loading blocked by failures with other queries in Power BI?
In Power BI Desktop, this error Loading blocked by failures with other queries Power BI usually occurs in the following cases :
- The Datasource settings have been changed.
- The Datasource Path has been removed or changed in case, you are using Excel or CSV file.
- The Datasource path is correct but it’s too long.
- The file name is too long.
- One or more fields have been renamed or removed in your main data source.
- One or more steps have an error due to missing field names.
- The data type of one field or more has been changed.
- You’re using outdated data connectors, so you have to update the Power BI Desktop to the latest version.
If you recently updated Power BI Desktop and your data source path and fields have not changed, you will only need to update the data source once more.
Solving: Loading blocked by failures with other queries Power BI
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:
The error “Loading prevented by failures with other queries Power BI” will appear if one of the aforementioned root causes are present, and you have to take the following action to resolve this error:
1) Update Data Source Settings in Power BI
- Open your Dashboard using Power BI Desktop.
- Click on “Transform Data” > Data Source Settings to manage the settings for your data source.
- Ensure that the Data Source Path is correct, and is not long, and try to update it by clicking on “Change Source”.
2) Refresh Data in Power BI
- Go back and click on “Transform Data” to open the Power Query.
- Go through each query and Refresh it even if it doesn’t show the warning icon.
3) Fix Applied Steps Error in Power BI
In case, you get an error message in your query when refreshing the data, you have first to fix it, and then review all the applied steps as stated below:
- In Power Query, Click on each query one by one under the Queries section on the left side.
- Then go through each step and ensure that there is no error in the applied steps.
In this step, you have to ensure that there is no missing field in the main query to get your data refreshed without removing the currently applied steps.
4) Using Advanced Editor in Power Query in Power BI
If you have renamed a field name or its data type 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 by doing the following:
- click on “Transform Data” to open the Power Query.
- The Power Query should be opened now, from the above ribbon, click on “Advanced Editor“.
- Review each step, and update the field name with the new name that you have changed in your main data source.
- At the end of the day, you have to ensure that there are no syntax errors have been detected as shown below.
5) Update the Power BI Desktop with the latest update
In case, the above steps don’t help to solve our main issue “Loading Blocked by Failures with other Queries“, so you have to download and install the latest version of Power BI Desktop at the official Power BI site https://powerbi.microsoft.com/en-us/downloads/
After installing the latest version, you have to update the data source setting once more as mentioned on the first step.
In conclusion, We have now thoroughly examined all potential causes and remedies for the challenging Power BI problem known as “Loading Blocked by Failures with Other Queries.“