Forum Discussion
Insert a new column into my Excel data but refresh dont work anymore
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
2 Replies
jthomsonSolution Sage
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
- Fowmy
Super User
Anonymous
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 🙂
