Forum Discussion
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
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.
1 Reply
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.