Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
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.
@caribbeansym 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.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |