Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Refresh error - Loading blocked by failures with other queries error

Hi all,

 

While refreshing the dashboard suddenly I have been facing the Loading blocked by failures with other queries error the reason is unknown. The error stays for seconds on the screen and disappears without refreshing the dashboard. However, when I refresh each file individually I don't face any error but when I perform schedule refresh for all the files together I face this issue. The data source here is sharepoint. If someone can help I have been behind this error for two weeks but unable to find the solution.

 

Thanks in advance. 

SpartaBI amitchandak 

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

     

    I'd like to suggest you check if the file is in the path and the file name is matched with that in Power Query.

     

    Best Regards,

    Stephen Tao

     

    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

      Yes the names are absolutely correct but still teh error is there any idea why ?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi all,

     

    I am still not able to refresh the dashboard and getting the same error it would be grateful if someone could help.Thanks in advance !

  • Did you find a solution for this?  I am getting the same error.  The only difference is that my scheduled refresh works just fine.  I am able to manually refresh all queries individually but I get the error when I refresh all together.  The error only stays for <1 second and then closes without the queries having been updated.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

      So I went through my data relationships. As observed once deleted the unnecessary relationships I was able to refresh the dashboard and ith no error. So please check the relations between the tables it will help. Hope this helps you find a solution