Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data loading error when refresh with some old data deleted from data source

Hi,

 

Usually my data source contains  monthly data file per year 2021, year 2022 and year 2023. Recently to make the file smaller, I have removed the year 2021 data. However when refreshing, it raises error loading blocked by other queries and then crash the process, so I can't even scan which query raises error. My power bi file is importing data by the prefix and the date string is at the end, so remove dates ideally shouldn't give errors. 

 

Thanks tons for any suggestions!!

Need Help

2 Replies

  • AbbasG's avatar
    AbbasG
    Memorable Member
    3 years ago

    Anonymous most common issue here might be, while removing 2021 data. Restore that data as it is and you might be able to decode what is causing the problem.

     

    After re-storing check your data in Power query if 2021 data is being used in some tables or queries. (if yes, you will need to get rid of those old data and make necessary tweaks).

     

    Hope it helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    An update is that now whichever PB file I open, it will raise "loading blocked by other queries" and then this diaglog disapeared, so I even don't know which exact query is causing error.