Forum Discussion

gvg's avatar
gvg
Post Prodigy
5 years ago
Solved

Table deleted long time ago not found while refreshing

Hi, I came up with this strange scenario, when Power BI Desktop is trying to find/refresh table that was deleted long time ago.  It says "Cannot find table 'xxxx'". Even if it "cannot find table" no...
Need Help
  • gvg's avatar
    gvg
    5 years ago

    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.

gvg's avatar
gvg
Post Prodigy
5 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.

Tabular Editor 

Power bi data model instance 

Regards,

Xiaoxin Sheng