Power BI : text case changing automatically

0 votes
So, my Power BI is connected to a SQL Server where I am reading a text field that is case sensitive in my sql server, but when the data arrives in power BI, it's all in the same case.

For example, in my database, I have the elements - "mixed", "Mixed" & "MIXED", when I read data from power BI all data is "mixed".

Can anyone tell me what's going on? Any help is much appreciated.
Nov 27, 2018 in Power BI by Upasana
• 8,530 points
26 views

1 answer to this question.

0 votes
Power BI doesn't handle case sensitivity that well after the query stage, at the moment. A current workaround is to create a dimension table with an index and work with that index instead.
answered Nov 27, 2018 by Shubham
• 13,290 points

Related Questions In Power BI

0 votes
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,060 points
611 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 14,090 points
116 views
0 votes
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 40,540 points
112 views
0 votes
1 answer

Programmatically sign in - power bi

Basically: POST request to: https://login.microsoftonline.com/common/oauth2/token Body, form-url-encoded: grant_type: "password" scope: "openid" resource: "https://analysis.windows.net/powerbi/api" client_id: ...READ MORE

answered Sep 19, 2018 in Power BI by Kalgi
• 40,540 points
83 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 8,530 points
43 views
0 votes
1 answer

Which query to use for better performance, join in SQL or using Dataset API?

DataFrames and SparkSQL performed almost about the ...READ MORE

answered Apr 19, 2018 in Apache Spark by kurt_cobain
• 9,240 points
107 views
0 votes
1 answer

How to connect Java program to the MySQL database?

You can connect your Java code with ...READ MORE

answered May 11, 2018 in Java by parth295
• 4,620 points
177 views
0 votes
1 answer
0 votes
2 answers

Power BI : Case Sensitivity

Oracle DB specific workaround, For Dimension & Fact ...READ MORE

answered Apr 26 in Power BI by Mahendra
182 views
0 votes
1 answer

Power BI : Time-based drill downs powered by Azure Data Warehouse

I don't really think you need to ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,290 points
75 views