Forum Discussion
Data source change error: "Loading blocked by failures with other queries"
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.
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.
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,
Yeah, but how to debug that?
How to find those tables?Where can I see the logs?
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
You are a life saver Yingjie Li, thanks a million man. This happened after i installed new version of Power BI desktop, it somehow changed datasource connections and now with your solution it is fixed.
