Insert a new column into my Excel data but refresh dont work anymore

[joseph248]

Hi Everyone, I need help. I added a new column (header) into my excel sheet (between existing column). When I press refresh, I get an error. How do I add new column into current excel data without importing the whole sheet again? Thanks,

[Fowmy]

@joseph248 

Check your Power Query steps to find out if any of the steps has Hard-Coded column names in it. If so, you need to adjust accordingly or recreate the steps so it always considers new columns.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[jthomson · Accepted solution]

This normally happens with .csv files (if it IS actually Excel it may not be applicable), PBI will usually indicate the number of columns that is in a csv in the first stage of the query, then do automatic type changing. If you stick something in the middle, then it'll move the last column out of the scope of what gets pulled in to PBI, then if it tries to change the type of the last column, it'll say it's not found.

Of course, knowing *what* error you are getting would be helpful