Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Orstenpowers
Post Patron
Post Patron

Data source (Excel) with additional column - how to add?

Dear all,

 

My original data, an Excel file, got an additional column. When updating my PBI file, I get the error message "The column "Column27" of the table was not found".

How can I manage that this additional column will be considered as well?

Thanks in advance for your help!

Best regards

Torsten

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @Orstenpowers ,

 

As amitchandak mentioned before, this issue should be a case of rename or column getting removed. I think it is easy to solve. You only need to remove the "Change type" step in APPLIED STEPS and then change column type manually.

1.png

In my sample, I rename Price as Price1 and add an ID column. Then refresh data and get this error.

2.png

I remove the "Change type" step in APPLIED STEPS and change column type manually.

1.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-rzhou-msft
Community Support
Community Support

Hi @Orstenpowers ,

 

As amitchandak mentioned before, this issue should be a case of rename or column getting removed. I think it is easy to solve. You only need to remove the "Change type" step in APPLIED STEPS and then change column type manually.

1.png

In my sample, I rename Price as Price1 and add an ID column. Then refresh data and get this error.

2.png

I remove the "Change type" step in APPLIED STEPS and change column type manually.

1.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Orstenpowers , this seems like a case of rename or column getting removed. Usually when column got added it add automatically.

 

Add the excel again in a new table, and in power, query copy the top code carefully and replace it with top code of your existing table.

Advance editor in Power Query, on the right click of a table 

 

Change Connection from One source type to another Source Type and use existing steps: https://youtu.be/nwYJgG2hmd0

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!