Forum Discussion
Column Missing While Changing Data Source
Hi Everyone,
I have been using an excel workbook to import the data into Power BI. When adding a column in the excel worksheet and updating the data source, it generates an error stating a column is missing.
The missing column is last column of the table and th additional column I have inserted is somewhere in the middle of the table. I tried the same process (adding 3 columns) with a dummy data and found that Power BI generates an error stating the last 3 columns are missing from the table. (When checking previous query on the step after which issue is getting generated, the last 3 columns are missing from that)
While transforming the data, I'm selecting worksheet not table, could that be the reason for this issue?
Any help would be really appreciated.
2 Replies
Anonymous - You would need to add the column headers in the step that is causing the error within Power Query or recreate the steps starting at the source. Basically, Power Query has had steps applied and hardcoded the values of the column headers into the applied steps. So you need to modify those bits.
Hi Anonymous ,
This is a common issue, you could refer to this similar post:
https://community.powerbi.com/t5/Desktop/PowerBI-Refresh-Column-Missing/td-p/1077432
Please check it in power query and adjust the error by steps.
This is the related document, you can view this content:
https://www.adoclib.com/blog/missing-column-in-power-bi-service.html
https://www.youtube.com/watch?v=YCCMCIktTdQ
https://community.powerbi.com/t5/Power-Query/Missing-column-when-refreshing/td-p/647133
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
