cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pchapple Member
Member

Changing column name in table when Database changed

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

1 ACCEPTED SOLUTION

Accepted Solutions
Habib Established Member
Established Member

Re: Changing column name in table when Database changed

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.

1 REPLY 1
Habib Established Member
Established Member

Re: Changing column name in table when Database changed

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.