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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Microsoft Employee
Microsoft 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.



Follow on LinkedIn
@ 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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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