Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Power BI should not change the casing of the data when displayed

Power BI Visualization is modifying my data. It specifically changes the casing of text.

 

My database in it's own has the right information. 

For example:

"CTRL", "Ctrl", "CTRL/Ctrl"

 

The datasource inside Power BI has the right information.

For example:

"CTRL", "Ctrl", "CTRL/Ctrl"

 

When it is displayed it is wrong, the casing is modified. 

For example:

"Ctrl", "Ctrl", "ctrl/Ctrl"

 

The view layer should not change the data. And I have seen this when I have a lot of data. So my guess is that there is a layer that is creating some indexing which is case-insensitive and then the index is used, if you want to have case-insensitive index, the index should have a pointer to the real value.

 

I have read ideas in the forums, such as modifying the data to trick PoweBI into thinking they are different, but I can't think of all posibilities here. I could have *ANY* combination. PLUS, I need to know exactly how the data is, that is the sole purpose of the report.

 

When is this going to be fixed?

Status: Investigating
Comments
Anonymous
Not applicable

@fdelagarza,

I will consult this issue internally and update here once I get any feedback.

Regards,
Lydia

Anonymous
Not applicable
 
Anonymous
Not applicable

@Anonymous,

I got response from PG:

"Not at the moment, but them adding votes to the ideas forum will help."

Please vote up this idea.

Regards,
Lydia