Forum Discussion
Removed Columns From My Dataset
Hi StevenH417 ,
When you loaded data from the excel files for the first time in Power Query, the script would have automatically detected the column names that were there in the file initially, something like
Now once you've removed a column fom source, the next time power query tries to load the files, it will load the same query again, only this time it will not find the column in the file. Hence, the error.
You will need to navigate to the step that has the error in Power Query, and remove any reference to the deleted columns.
I suggest trying this on a copy of your original pbix so you have a backup copy.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
Hi StevenH417 ,
When you loaded data from the excel files for the first time in Power Query, the script would have automatically detected the column names that were there in the file initially, something like
Now once you've removed a column fom source, the next time power query tries to load the files, it will load the same query again, only this time it will not find the column in the file. Hence, the error.
You will need to navigate to the step that has the error in Power Query, and remove any reference to the deleted columns.
I suggest trying this on a copy of your original pbix so you have a backup copy.
Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
Thank you so much! I have much to learn and I greatly appreciate the community being here to help!
