Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
centroid
Helper I
Helper I

Refresh: "Loading-blocked-by-failures-with-other-queries" - unknown reason for bug

I have about about 20 different data sources, from ODBC, and Excel.

 

During refreshing, I am getting the error:  "Loading-blocked-by-failures-with-other-queries"  for all data sources, without any indication why this error occurs. How do I find out, what is going wrong here, in detail? I have no idea what causes this problem.

5 REPLIES 5
jwilson10533
New Member

Hi @centroid , I removed this error by following @amitchandak method of going down the connections one-by-one, I found I had an Excel file open which was blocking the load which for some reason blocked all the loads.  With file closure, files loaded individually and also then in mass.    Hope that helps.

Anonymous
Not applicable

How did you fix this I am dumbfounded 

v-henryk-mstf
Community Support
Community Support

Hi @centroid ,

 

For this type of error, it may be due to the data source file being moved or renamed. You can open the Convert Data/Edit query and check for specific errors by clicking on the table. Also for refreshing, are your operations done in a desktop or service environment?


Alternatively you can refer to the following video content. How to Change Connection Details

In addition, a similar solution.


If the problem is still not resolved, please point it out and provide related operation screenshoots. Looking forward to your reply.


Best Regards,
Henry


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@centroid , if this a scheduled refresh on power bi service. You should be able to see reason on click or should be able to download an excel and see that. One table will have a different error.

 

In the case of desktop also one table will have a different error.  Else refresh one by one and check

 

Anonymous
Not applicable

you need to quit posting this. I see it everywhere and hasnt been a solution, different error. Thank you

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.