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
Here is another way to fix this. Follow these steps in the same order.
1. Before you begin, make sure your excel file has old column name (EDW GM (Qta) in our example) and Power BI Tables also show the old name. AND you are able to Refresh successfully.
2. Open Excel file, change column name to new value ESC GM (Qta)
3. Open Power BI, click refresh. It will throw error "Column name EDW GM (Qta) not found"
4. Right Click Table Name in the Fields menu. Select Edit Query
5. In the formula bar, locate the old column name, it should be something like {"EDW GM (Qta)", type text} ... and change it to {"ESC GM (Qta)", type text}.
6. Apply and close Power Query Editor
7. Refresh
8. You're welcome!