Forum Discussion
Datasource column name changed
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
Just had this happen to me as I connect to a file stored on sharepoint. Problem is, many mangers have their hands on the file and make changes, one being the column name.
My simple solution is:
1. open the query editor
2. Expand the formula bar, then start clicking the steps starting from the last step.
3. When you see steps that start listing the column headers, simply find the column name that changed and make the update directly in the formula bar to the new name. This is normally in the very first step after promoted headers step and any other column that had filters steps.
4. You can tell you made all the correct changes when you can click any step and don't get an error.
5. Close and load.
This works for getting the refresh to not show an error, but it makes my visualizations show an error until I redo the edited column. Is there a way around this?
