Forum Discussion
Case sensitivity in Power BI Desktop
I'm noticing a discrepancy between our Oracle DB and Power BI reports. In Oracle DB, the values for 'RepairNotes' are displayed as 'NTV Check' and 'NTV check' (with different cases). However, when I run the report in Power BI, both values appear as 'NTV Check' (with the same case) In Direct Query. Could you help me understand why this is happening and how we can resolve it? amitchandak
5 Replies
- zenisekd
Super User
You can rename the column name on the report and on the visual level. Any chance, this was done?
v-sgandrathiCommunity Support
Hi Sudhasranreddy,
Thankyou for reaching out!
This behavior is often controlled by visual formatting or locale settings, and can unintentionally mask case differences.
Here are a few ways to address this:
-
Use a table visual with no grouping or sorting to inspect the raw values — this helps confirm if Power BI is returning the original case.
-
If case distinction matters, consider adding a calculated column using UPPER() or LOWER() in Power BI to explicitly standardize the format.
-
Alternatively, switch to Import mode, which gives you more control over how data is shaped and avoids any unexpected DirectQuery optimizations or query folding.
-
If needed, custom visuals or column formatting may help preserve and present values exactly as stored in the source.
If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!
Thank you.
- v-sgandrathi
Hi Sudhasranreddy,
As we did not get a response, may I know if the above reply could clarify your issue, or could you please help confirm if we may help you with anything else?
And if the provided information meets your requirements, you can Accept the solution and also give Kudos on that reply. It helps other users who are searching for this same information and find the information.
Your understanding and patience will be appreciated.
- v-sgandrathi
I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.
Than you.
-
