Changing the name of a data set field - Powerbi

Question

Hello I have a data set (Excel) that was loaded in Powerbi. When I change the name of a column/field in Excel Powerbi does not actualize the data because it does not recognize the name of the column that was renamed in Excel. How can I make Powerbi understand that the column/ field is still the same but only had the name of the field changed?

Answer 1

The steps are as follows:

Goes into Edit Query:

Select the table showing the error ( In my case with the name 'Plan 1' ) right click on it and then select Advanced Editor:

In the window that opens you will have to change the name of the old column to the new one manually. In my example I previously had a column with the name 'COLUNA3' and wanted to change his name to 'COLUNAC'. Take the example:

1 - Before the Column Name change.

2 - Result after changing.

Once done, just update the table and use normally.