Solved: Insert a new column into my Excel data but refresh...

joseph248 · ‎11-05-2020

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,

jthomson · ‎11-05-2020

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

View solution in original post

Fowmy · ‎11-05-2020

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up

⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

jthomson · ‎11-05-2020

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