Power BI : Case Sensitivity

0 votes
Can we configure the case sensitivity in Power BI?

I'm asking because I have data in an Oracle DB (where a primary key EXample is different from exampLE). All I want to know is, if it will work if imported to Power BI?

Thanks.
Jan 2 in Power BI by Upasana
• 8,210 points
74 views

2 answers to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

As of now, I think the best option would be to create an index for your primary key in the query editor stage and so you could use that index in Power BI for your relationships, like so :

http://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/

answered Jan 2 by Shubham
• 12,890 points
0 votes

Oracle DB specific workaround,

For Dimension & Fact keys use ORA_HASH() function which will generate unique integer for case sensitive keys. Using ORA_HASH function you will get distinct values for key value "EXample" & "exampLE".

SELECT ORA_HASH('EXample') AS KEY1, ORA_HASH('exampLE') AS KEY2 FROM DUAL;
answered Apr 26 by Mahendra

Related Questions In Power BI

+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,080 points
74 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
• 36,870 points
66 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
• 36,870 points
43 views
0 votes
2 answers

Passing parameters to Power BI filter programmatically

In addition to @Kalgi's answer, there's another ...READ MORE

answered Sep 19, 2018 in Power BI by Nilesh
• 6,900 points
1,618 views
0 votes
1 answer

Error while communicating with remote Oracle DB through Jenkins-CI

I was also facing the same problem. ...READ MORE

answered Apr 25, 2018 in Jenkins by shubham
• 6,640 points
64 views
0 votes
1 answer

Error while talking to remote Oracle DB using Jenkins-CI

I installed Oracle XE to talk to ...READ MORE

answered May 1, 2018 in Jenkins by shubham
• 6,640 points
185 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,060 points
53 views
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
423 views
0 votes
1 answer

Power BI : text case changing automatically

Power BI doesn't handle case sensitivity that ...READ MORE

answered Nov 27, 2018 in Power BI by Shubham
• 12,890 points
18 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
• 12,890 points
27 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.