Forum Discussion

Serj's avatar
Serj
Frequent Visitor
3 years ago
Solved

Loading blocked by failures with other queries

Hi all, There are already several topics with a similar issue on this forum, however, I haven't found a solution that would work for me. Could you pls kindly advise me on how to deal with it in my c...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Serj ,

     

    This issue should be caused by something wrong in any data source refreshing. 

    How did you check your data source? Here I suggest you to refresh each table in Power Query Editor and check which one will return error in refreshing. Then do some troubleshooting on the error. 

    As far as I know, many times these issue may be caused by invalid or incorrect data source credential.

     

    Best Regards,
    Rico Zhou

     

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

     

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Serj ,

 

This issue should be caused by something wrong in any data source refreshing. 

How did you check your data source? Here I suggest you to refresh each table in Power Query Editor and check which one will return error in refreshing. Then do some troubleshooting on the error. 

As far as I know, many times these issue may be caused by invalid or incorrect data source credential.

 

Best Regards,
Rico Zhou

 

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

 

 

Serj's avatar
Serj
Frequent Visitor
3 years ago

Hi Anonymous ,

I identified a problem in one of the Helper Queries that referred to an old datasource location not existing anymore. Once I removed it, the refreshing went well. However, it really took a while to find a problem with a single query out of 100+ other ones. Thank you!