Changing column name in table when Database changed

[Anonymous]

Im hoping this will be a simple change...

I download my data from an external site, andhave built a Power BI dataset around its export format.  BUT, they've just changed the title of one of the columns, so my data 'refresh' say...

Expression.Error: The column 'Service Composite' of the table wasn't found.

What do I have to do to make Power BI see the newly named column (new name 'Location1 Service Composite')

Thanks

[Habib · Accepted solution]

Perform following action

1. Go to Edit Quieries Option
2. Select the table for which column name was changed.
3. Select the column (for which name was changed, it will be appearing with new name) and rename it to Old column name.
4. This will add another step in Applied Steps section

After saving and closing the Query Editor, your data set will be ready for use as of previous one.