Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Hi @adarshalok ,
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.
@adarshalok - 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.
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
84 | |
68 | |
49 |
User | Count |
---|---|
138 | |
111 | |
103 | |
64 | |
60 |