Data source columns are renamed from lower case to upper case. Visuals breaks

[pranavk_pbi]

If in data source columns are renamed from lower case to upper case. In power query the change is taken care but at report level the visuals does not recognise the fields with new names or auto detects it. Any solution to it please ?

[Anonymous · Accepted solution]

Hi,

Thanks for the solution divyed  and Kedar_Pande  offered, and i want to offer some more inforamtion for user to refer to.

hello @pranavk_pbi , it is better that do not change the column name ususally , if you change the column name, you need to refresh the report first,  and the new column name in table will change,but  the original column name in visual will not change.

if you want to change the column name dynamically in visual,  it cannot support.  you need to  remove the original column name from the visual manually, then reput the new column name to the field

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kedar_Pande]

@pranavk_pbi 

Refresh Data: After renaming columns in Power Query, refresh your data model to ensure Power BI recognizes the changes.

Update Visuals: Manually update the visuals by clicking on the visual, then going to the fields pane, and selecting the renamed fields.

[divyed]

Hello @pranavk_pbi ,

When columns are renamed in the data source (e.g., from lowercase to uppercase), Power BI's Power Query will capture these changes, but existing visuals might still reference the original column names and may not automatically update to the new names. Here is something you can do.

• Refresh Data in Power Query:

  • Go to Power Query Editor in Power BI and refresh the data by clicking Close & Apply. This ensures Power Query recognizes the updated schema.

• Field Re-Mapping in Visuals:

  • If visuals are not recognizing the new column names, you’ll need to manually re-map the fields. For each affected visual:
    • Open the visual in Power BI Report View.
    • In the Fields pane, remove the existing field(s) that reference the old names.
    • Re-add the updated fields (with new uppercase names) to the appropriate visual slots.

• Verify and Test:

  • After re-mapping, verify the visuals to ensure data is displayed as expected.
  • Save and refresh the report to confirm that the new field mappings are consistent.

I hope this helps.

Did I answer your query ? Mark this as solution if this helps. Appreciate your Kudos.

Cheers

[pranavk_pbi]

@divyed divyed

I have 100+ visuals in the report, manual changing fields will be a huge effort. Thats why asking here, is there a solution to it or manually only can be achived ?  

[divyed]

Hello @pranavk_pbi ,

It will be manual IMO , Power BI does not currently support automatic field remapping in visuals but you can use tabular editor to reduce manual effort. 

1. Use tabular editor to write script to bulk update field names

2. Once script is complete, save and refresh your report in power bi

This approach ensures that all references to column names are updated in one step without manually changing visuals.

I hope this helps.