Solved: Changing column name in table when Database change...

Anonymous · ‎07-21-2016

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 · ‎07-21-2016

Perform following action

Go to Edit Quieries Option
Select the table for which column name was changed.
Select the column (for which name was changed, it will be appearing with new name) and rename it to Old column name.
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.

View solution in original post

Habib · ‎07-21-2016

Perform following action

Go to Edit Quieries Option
Select the table for which column name was changed.
Select the column (for which name was changed, it will be appearing with new name) and rename it to Old column name.
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.