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.

     

v-yingjl's avatar
v-yingjl
Community Support
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.

 

Watersu's avatar
Watersu
New Member
3 years ago

Hi,

in this error happens when we remove a column from a table only, when we forget removing the same column(s) from the syntax that we wrote. So, if we delete those columns from the syntax that we removed from the table, you will not see the error again. 

Thanks