Forum Discussion

jjlek's avatar
jjlek
Frequent Visitor
7 years ago
Solved

Column renaming breaks existing reports on same data source

Hi all,   I'm facing the following situation: I have originally published a report and its underlying dataset from Power BI desktop to Power Bi services. From there multiple reports were already cr...
Need Help
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi, jjlek 

    You may need to replace the field on visuals manually.

    When you rename the column in the dataset, the fields name on visual won't be replace and couldn't match with new fields.

    So just adjust fileds of visuals in these new reports manually.

    For example, I change the name of the column in dataset from Qty to Value. Now just adjust it manually in Edit View in power bi service.

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi, jjlek 

You may need to replace the field on visuals manually.

When you rename the column in the dataset, the fields name on visual won't be replace and couldn't match with new fields.

So just adjust fileds of visuals in these new reports manually.

For example, I change the name of the column in dataset from Qty to Value. Now just adjust it manually in Edit View in power bi service.

 

Best Regards,

Lin

jjlek's avatar
jjlek
Frequent Visitor
6 years ago

This is rather dissapointing, as similar tools would give you the option to add an alias or friendly name to a column, without changing the actual name within the data model.