Power BI Case Sensitivity

Question

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.

Answer 1

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/

Answer 2

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;