Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi,
I am using direct query approach in my report. Search option is case senstive in my report
how to make this search option as case insensitive in my report ?
I have read this Article but not sure how to solve my issue
https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/
Solved! Go to Solution.
Hi @Anonymous ,
Power BI is always case sensitive to my knowledge. There is an idea to change this here:
https://ideas.powerbi.com/ideas/idea/?ideaid=a9843990-64f6-ea11-b5d9-281878bdaa58
I use two different work-arounds for this. I will make the entire column one case (all uppercase) and that solves it. But, that isn't always the way I want to the data to be presented so sometimes I will create a second field, make it all uppercase, use that new field for the search and then only display the original version. Again, not perfect but it works in some situations.
I also found this article that gets around it with some M code:
https://www.thebiccountant.com/2016/10/27/tame-case-sensitivity-power-query-powerbi/
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @Anonymous,
Since you are working with the direct query mode, I'd like to suggest you consider using T-SQL statement to append a custom field that used to upper/lower case the values of the specific fields.
After these steps, you can directly search for new fields without worry about case sensitive scenarios.
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
Power BI is always case sensitive to my knowledge. There is an idea to change this here:
https://ideas.powerbi.com/ideas/idea/?ideaid=a9843990-64f6-ea11-b5d9-281878bdaa58
I use two different work-arounds for this. I will make the entire column one case (all uppercase) and that solves it. But, that isn't always the way I want to the data to be presented so sometimes I will create a second field, make it all uppercase, use that new field for the search and then only display the original version. Again, not perfect but it works in some situations.
I also found this article that gets around it with some M code:
https://www.thebiccountant.com/2016/10/27/tame-case-sensitivity-power-query-powerbi/
I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Proud to be a Datanaut!
Private message me for consulting or training needs.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.