Forum Discussion
Missing column when refreshing
Thanks for your answer and your time.
Ufortunately, noone's been in the report (nobody else knows how or has a license), and there haven't been made any changes to the Excel file that causes the error. The data that gets updated weekly is in another Excel file entirely.
I actually ended up just removing that particular sheet/table from the report, since it was data that I only might be needing in the future. Now everything is back to normal in the report. :smileyhappy:
hi, i noticed this error too when i have data refresh via pbi online dataset refresh. An error appears saying that there is "Missing ColumnXX" even when the Column is not even coded in the query.
When we download the actual pbi file and do a manual refresh, no error happens and just reupload the refreshed pbi file. Kind of weird that such an error can happen when we refresh our dataset online but doesnt happen when we do it via pbi desktop and it inevidently becomes a fix.
It is as though, there is a shadow code in the background that influence the refresh via pbi online.
Any thoughts from the community on this?