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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello, thanks for your answer v-yingjl 

 

I figured out that two tables are not loaded properly and it produces conflict when change data source.
I find and deleted those tables and worked properly as you suggest.

 

Greetings,

 

fmantovani's avatar
fmantovani
Regular Visitor
4 years ago

Yeah, but how to debug that?
How to find those tables? 

Where can I see the logs?