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.

     

Muthu-Raja's avatar
Muthu-Raja
Regular Visitor
4 years ago

Using Power Query editior can resolve this error,

 

First we need understand what is the error, we have to identify the missing part eaither it could be any column missing in latest report it was there in previouse the lates report not there mostly this is the major issue.

 

while transforming data to power BI the power query will record the data and save those steps as you can see in right side , like date type chenge, column removed, colum type changed, Now here is the actual challenge you have to identify the issue and resolve here,

 

Ex:- ive created one working file uploading some data to PowerBI now im tranforming the data, here im changing the column 2 as date and column 1 as text and delete column 3 and 4 this steps are recorded and saved,

 

Now the next day im refreshing updated data but i did some modification in data sheet.

 

what i did ? deleting column 3 and 4 and im refreshing,

 

what will happen?while tranforming data the power query recorded steps will check the conditions ,if column 3 and 4 not available the power Query will not allow to refresh the data.

 

Then how to resolve this issue ?

 

Solution here :- go to power query editor remove the recorded steps like above mention steps "delete column 3 and 4" 

now power bi will allow to refresh the data.

 

i hope you accecpt this solution