Forum Discussion
no data on data query - Excel tables
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.
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 QueryRegards,
Xiaoxin Sheng
2 Replies
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
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 QueryRegards,
Xiaoxin Sheng