Forum Discussion
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 ra...
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.