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.

     

Coriel-11's avatar
Coriel-11
Resolver II
2 years ago

I had this issue. What it turned out to be for me was I'd changed the names and targets of a bunch of parameters I'd used to refer to locations in Windows Explorer. Once I took out the old ones it worked fine. Not sure what that was about. Perhaps there were two pointing at the same target or something????
Anyway, it works now.

Matt