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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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