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:
First thing I always ask is "WHO touched my report?" If no one answers, check the data. Finally, check the queries.
For Excel data, the most common error I might expect for this errror is an unexpected comma. Maybe a number entered with commas (1,000) when that isn't supposed to be allowed. Or a comma in the middle of a first or last name without quote marks surrounding it. OR a missing comma. Especially at the top of a data set. The commas control the column count.
As a long time data developer, if I'm reasonably certain no one has touched the program/report, then I assume a data problem and am usually right. Especially if these spreadsheets are created by hand or can be edited by hand after being exported by some program.
If there is any chance some has opened the report in Power BI Desktop and looked at the queries, then you can use Edit Queries to look through the Applied Steps for column lists. You don't need to know the syntax to recognize a list of column names and determine that there is an extra one or that one is missing.
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: