Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
amabrenda1986
Resolver I
Resolver I

Impact of Changing Column Name when Data is refreshed from Source

Hello 

 

I have the sample table below spulled from a DB. If e.g. I change the name of a column from value_ndc_assignto_value@odata to Assign To, what would be the impact when the data is to refershed? if it will impact the data refersh when making calls to the DB, how can i change the display name, so that the visuals would only show the name I want it to show?

 

 

amabrenda1986_0-1693960892006.png

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @amabrenda1986 
You can change column names freely in 3 ways (without any effect to refresh process.
1. From PQ 

Ritaf1983_0-1693966833341.png

Then you can see the history of your changes as recorded steps :

Ritaf1983_1-1693966891668.png

2. On data view

 

Ritaf1983_3-1693966990909.png

or on visuals only then you can keep your original names

Ritaf1983_4-1693967207941.png

You can also refer to the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/Does-renaming-column-headings-affect-refresh-data/...

 

 

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



Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

1 REPLY 1
Ritaf1983
Super User
Super User

Hi @amabrenda1986 
You can change column names freely in 3 ways (without any effect to refresh process.
1. From PQ 

Ritaf1983_0-1693966833341.png

Then you can see the history of your changes as recorded steps :

Ritaf1983_1-1693966891668.png

2. On data view

 

Ritaf1983_3-1693966990909.png

or on visuals only then you can keep your original names

Ritaf1983_4-1693967207941.png

You can also refer to the linked discussion :

https://community.fabric.microsoft.com/t5/Desktop/Does-renaming-column-headings-affect-refresh-data/...

 

 

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



Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.