rename column in dataset

[hi_world]

Hello, 

When renaming column in dataset, all visual created based on this dataset using the column will broke. 

how to get around this problem?  Is there an idea microsoft working on it ?

Best regards

[hi_world]

hi @Anand24 

I think I misspoke.
I have created a dataset test and publish him in service powerbi, then i create a new report reportTest using as data source the dataset test.

Now, i change a column name in dataset test from column1 to column2 and publish him in the service, then the visual in reportTest using column1 will broke. 

how to circumvent this problem ?

Thank you for your help in finding a solution.

[Anand24 · Accepted solution]

@hi_world ,
This is actually expected behaviour of Power BI and yes it is still a limitation.
Two solutions:
1 - Manually replace each renamed column in the visual - This is going to be a tedious task
2 - Refer to Solution of this thread 

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[hi_world]

Hello Greg,
Basically I modify the name of the columns in the power query.
I tried to modify the name of the column in the power bi desktop (report) and I have the same error message.

why the powerbi report which is based on a dataset fails to detect that a column name is modified instead of displaying the error message One or more fields have a problem....

Best regards

[Anand24]

Hi @hi_world ,
Power BI usually does detect the renaming of fields from Power Query and even at normal data tab/dataset end. It evem detects and auto-changes the calculated columns/measures created on top of those renamed fields.

Can you check what error does the visuals show when you click on "See details" when visual error occurs?

Please re-check the dataset you are using to ensure there is:
1. No table structure change

2. No renaming of any field at database level

3. No removal of any field at database level

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! LinkedIn

[Greg_Deckler]

@hi_world If you double-click the column in the Data pane in Power BI Desktop and rename it, all visuals should still work. How are you renaming the column in the Service?