Forum Discussion
Table deleted long time ago not found while refreshing
OK, thing is that I had a few measures that referred to the deleted table. Surely they were with errors. It looks like Power BI analyzes everything (tables, measures) defined in Desktop and tries to load them alongside what is defined in Power Query. Do not know what is the logic behind this, but that's how Microsoft designed it.
Thanks for the hint. Sure I refreshed my model a number of times. I have now cleared everything from TempSaves and also Cache, but the issue is still there. Strangely enough refreshing in Power Query (Refresh All) goes smoothly without any error message. However when I click Refresh in Power BI Desktop itself, I end up with the above mentioned issue.
OK, thing is that I had a few measures that referred to the deleted table. Surely they were with errors. It looks like Power BI analyzes everything (tables, measures) defined in Desktop and tries to load them alongside what is defined in Power Query. Do not know what is the logic behind this, but that's how Microsoft designed it.
Had the same issue. Was sure I hadn't used the deleted table in any measures, but checked each one and what do you know? Yep, removed the offending measure and it was all good.
Hi gvg,
It sounds like internal dependency related issues that power bi does not contain functions to troubleshoot and fix this scenario.
Perhaps you can try to rebuild your report on the new pbix file and check if this issue appears again or try to use the tabular editor or SSMS to open the instance to check them.Regards,
Xiaoxin Sheng
Your 5 years old post just saved me. Amazing!
