Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data source change error: "Loading blocked by failures with other queries"

Hello all, I have a powerbi model which connected to "A" database. It has both import and direct-query modes. Now I need to change this data source to "B" database which has same structure ( you ...
Need Help
Show and Tell
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    I’m not certain which reasons cause this, did you have access to database B or whether there are other queries in it expect A and B or any other scenarios? Could you share more detail like how you change the data source and so on for further discussion?

     

    I have change the data source in this way in my environment and it seems ok, perhaps you can try it:

    Power Query Editor -> Data source settings -> Change data source

    Best Regards,

    Yingjie Li

     

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

     

PBINewbie1308's avatar
PBINewbie1308
New Member
3 years ago

This can also be a simple fact that the directory titles are too long. I have just solved my issue by clicking on the error and i could see that the directory path was way too long. 

Resolved by shortening the path.