CODEWITHSUNDEEP
oracle-databasepowerbicase-sensitive
Mathieu Ricour
Mathieu Ricour

Reputation: 378

Case sensitivity in Power BI

I wanted to know if it's possible to configure the case sensitivity in Power BI. I have data in an Oracle DB where a primary key EXample is different from exampLE. But if I want to import it in Power BI, it won't work.

Any idea ?

Upvotes: 3

Views: 1343

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

For now, I think your best bet would be to create an index for your primary key in the query editor stage and then use that index in Power BI for your relationships.

This is outlined here:

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

You can also vote for case sensitivity to be configurable here:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17235656-case-sensitive-insensitive-option

Upvotes: 2

Related Questions