Forum Discussion
Datasource column name changed
Hi PBI, If a column header name for my source data changed, how to I update PBI so moving forward I use the new header name.
You might find the reason and the solution here: http://datachant.com/2017/01/06/10-mistakes-you-always-do-in-powerbi-powerquery/
If not: Click on "Go to error" - this will send you to the step where the error occurs. Show Formula-bar -> copy & paste the code here for further analyzing.
thanks.. Looks like the steps are (1) connect to the file with new header (2) after error pop up, manually change the header in EDIT Queries. (3) Refresh data and PBI Desktop Report will capture will header
Manually edit it/them from Advanced Editor.
The box contents tells which column it's refering to. Change the old column name to the new one.