Column Missing While Changing Data Source

[adarshalok]

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. 

[v-yangliu-msft]

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.

[ChrisMendoza]

@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.