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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
v-yuezhe-msft
Employee

@fdelagarza,

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

Regards,
Lydia

v-yuezhe-msft
Employee
Status changed to: Investigating
 
v-yuezhe-msft
Employee

@fdelagarza,

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