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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PaulPalkowski
Helper II
Helper II

Case Sensitivity

I need/want to maintain Case Sensitivity when creating reports. 

It seems that PowerBi now changes the case on my excel data source as seen on this table visual

How can I fix this?

excel.pngtable visual.png

 

1 ACCEPTED SOLUTION

Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive. 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

7 REPLIES 7
PaulPalkowski
Helper II
Helper II

Thank You!

You're welcome!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





HarishKM
Impactful Individual
Impactful Individual

@PaulPalkowski Hey,
Kindly refer below webpage.

Power BI: How To Transform Data To Uppercase (quicklylearnpowerbi.com)

 

or 

you can go power query 

select column => transform => you can select "capitalize each word"
to get all word as same in your excel.

 

Thanks

Harish
Did I answer your question? Mark my post as a solution!

no, i want to keep the data as entered... What I shared was only an example. What I have is product assignment naming conventions such as 1524E-PP and 1524E-pp where the PP means it has been inspected and the pp means it has not. The are many variations such as e1487-c is aprototype but e1487-C is and approved part. The letter's case in the hundreds of part numbers represents various stages.

audreygerred
Super User
Super User

Hello! The main engine of Power BI is case-insensitive. However, you can create a workaround for this by creating an index for the different case values in Power Query because case-sensitivity is recognized there. Here is a blog that should help explain in more detail: Letter case-sensitivity in DAX, Power BI and Analysis Services - SQLBI




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





I thought at one time, case sensitivity was not auto-corrected in PowerBi . Did this change or perhaps I am thinking of relationships between tables or some other element.

Power Query is case-sensitive, that's why you can add an index there to protect your sensistivity since Power BI is case-insensitive. 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.