cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Samy-Elsayed
Regular Visitor

How can i use Case Sensitive feature in power bi

Hello Dears,

The data that I import from redshift and SQL server to power bi  is case sensitive, but when I started to use it in the visualization or in analysis in excel the filter didn't return all the records that have the same letters just it returned on record 
Ex: if I have transactions in the database for the following accounts
google
Google
GOOGLE

it became just one record in power bi


any solutions?

 

1 ACCEPTED SOLUTION
ribisht17
Memorable Member
Memorable Member

@Samy-Elsayed 

 

Chris Webb's BI Blog: Power BI And Case Sensitivity Chris Webb's BI Blog (crossjoin.co.uk)

 

>>

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case insensitive. Imke Feldmann shows how to make Power Query case insensitive through custom M here; in this blog post I’m going to concentrate on what case-insensitivity means in datasets and DAX and show a way to (kind of) work around it.

 

Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

View solution in original post

4 REPLIES 4
isabella
Microsoft
Microsoft

Hi @Samy-Elsayed 

 

The power bi desktop is case insensitive,you can’t change it ,but we can make google,GOOGLE ,or  Google different separately.

My method is to can add an index column in power query ,then merge the two columns.Hope this will helps.

isabella_0-1652853665132.png

 

 

Best Regards,

Community Support Team _Isabella

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ribisht17
Memorable Member
Memorable Member

@Samy-Elsayed 

 

Chris Webb's BI Blog: Power BI And Case Sensitivity Chris Webb's BI Blog (crossjoin.co.uk)

 

>>

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case insensitive. Imke Feldmann shows how to make Power Query case insensitive through custom M here; in this blog post I’m going to concentrate on what case-insensitivity means in datasets and DAX and show a way to (kind of) work around it.

 

Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

Thanks for your advice, its working now

Kindly i need to apply on column from query , I tried to add this column to apply but I couldn't ,

kindly advice

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors