Data Display issue in PowerBI Report

[Tirtha]

Dear folks,

I just have an issue where a particular value in data source has been chnaged in display in a text table report. I have column cell value abc.startTime. The same value is displayed in the query editor. However when I load it to the model, it displays as abc.starttime. "T" is lowercased. I have tested with uploading fresh data with same value it works correctly.

Your advice would be very helpful.

[v-pgoloju · Accepted solution]

Hi @Tirtha 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[danextian]

Hi @Tirtha 

Other than applying a lowercase transformation to a column, the possible reason is that your data has rows for both abc.startTime and abc.starttime. Power BI is case-insensitive when loading data into its model. This means that "ABC" and "abc" are treated as the same value in a column. The reason for this behavior is that Power BI is built on VertiPaq, which follows a case-insensitive collation for text data. This in-memory storage engine compresses and optimizes data. Since it treats "ABC" and "abc" as the same value, only one of them is stored  - the first occurence.

[Tirtha]

Hello @danextian  thank you very much for your response. Its really insightful and this is what I have thought but you have given a lot more context. Yes, that is correct I have two three rows with abc.startTime, one with upper T in Time and one with Lower "t" in time. But these values are critical to be retained as they are in the source. Is there any way to display the values as they are?

Thanks again.

[danextian]

You can add a column that converts the text to binary and then to a readable Base64 encoded string if you want to differentiate a row with the same value from another. However, VertiPaq will still kick in for the original text.

[Original Text] & "_" & Binary.ToText(Text.ToBinary([Original Text]), BinaryEncoding.Base64)

Also, do not attempt to use DAX to extract the text before _ in the screenshot below as VertiPaq, again, will still kick in.