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
DavidBrunaugh
Regular Visitor

Power BI Desktop automatically changes column names

I have several power bi reports that I manage. Each of them connect to data in our Dataverse environment. For months I have been able to use power query to add an remove columns from the report without issue. Recently when doing this I noticed most (if not all) the column names in the table I edit will be changed automatically from their schema names to their display names. If these columns are referenced by any measures in the power bi report those measures will break because they will not find the column using the old schema name. I have to open each measure and change the column names to the display name to fix the measure. Is there a setting that can prevent the names from being changed in the first place?

 

   Here is a screenshot of a table that still has the old schema names.

DavidBrunaugh_1-1660664762578.png

Here is a screenshot of a table I just modified in Power Query. All the column names have been changed to their display names automatically.

DavidBrunaugh_0-1660664740670.png

1 ACCEPTED SOLUTION
3 REPLIES 3
MoraesLucas
Regular Visitor

I mean should be possible to leave the name set previously on power query editor? or simply deactivate auto naming columns? 

Because the only way to renaming columns is in propeties view 😕 
Even if you aready set names in power query.

MoraesLucas_0-1690381023171.png

 

MoraesLucas
Regular Visitor

There is a way to deactivate this? Cause my reports are losing names that i set previously... 
The only way to rename AGAIN is in propeties from table.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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