Background to my issue: I have monthly data for two years for around 10 regions.
Each month for each region is a separate table. So what i have done is appended 12 months tables into 1 new table for each year by region; and then subsequently appended this yearly tables by region. This gives me 10 master tables [i disabled load on all old tables to save time and memory]. Its based on these 10 tables that i have written all my measures.
Now the problem is none of these 10 tables aren’t loading in the power query. It was working fine until a few days back. Now it just keeps loading forever; and system heats up running this. Pls help me solve this. I have been working on this model for weeks now.