no data on data query - Excel tables

[ofarrera]

Hi guys, I am running into a similar problem here. I tried to refresh my charts using Power Bi Desktop but when I tried I am gettting the following error plus no data is shown on the Data Query. I have tried all the things on this blog plus closing and reopening Power BI with no success. 

Here are my screen shots. 

[v-shex-msft · Accepted solution]

HI @ofarrera ,

I guess your table structure has been changed on datasource side, right? If that is a case, you need to manually find out these unmatched fields and fix them.

AFAIK, power query tables not support dynamic table structure. (Data structure will cached in query steps when get data)
Handling Added Or Missing Columns In Power Query

Regards,
Xiaoxin Sheng

[Anonymous]

Hello @ofarrera ,

the error seems to be looking for a column named  "column1" 

i would check collumns you may have deleted or renamed.

as for your equasion, i can not find anyting for DAX of .removecolumn

it is likely once you fix the error your data will show

hope something helps, 

Collin