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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
slawomirdrzymal
New Member

Error while changing column name

Hello there,

 

I have noticed that when i am chaning the column name without changing its characters - for example from "Atribute Name" to "atribute name" i have an error:

The name "atribute name" is already used for a column on table "table name". Choose a different name.

 

pq_blad.png

 

It seems like this is a bug.

 

The workaround is to change the name to another temporar value and than change again to the desired column name.

3 REPLIES 3
v-caliao-msft
Employee
Employee

Hi Slawomirdrzymal,

 

According to your description, you are experiencing the issue when changing a column name for "Atribute Name" to "atribute name", right?

 

I have tested it on my local environment, we can reproduce this issue. Based on my research, it seems that the obecjt name on Power BI are case-insensitive. So the name "Atribute Name" and "atribute name" were treated as the same name.

 

If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

Charlie Liao

There is already one idea regarding to case insensitive, please check: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12423990-case-sensitivity-as-an-o...

Greg_Deckler
Super User
Super User

Not sure if it qualifies as a bug, it is just the nature of the modeling engine, column names are case insensitive. For example, if you have a column called "Hours" and you create a new column called "Column" and you give it as its formula:

 

Column = [hours]

or

Column = [Hours]

or

Column = [HoUrS]

or

Column = [HOURS]

They all work.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors