Why a value in a text column in powerBi gets changed by itself?

[chwostian]

Hi there,

Does anyone know what might be the reason that the value in powerBI in a text column gets changed to lowercase by itself? This isn't a rule for every value in a text column.

Thanks for any hint

Best regards

JK

[avatorl · Accepted solution]

It's not a bug. It's by design. This article explains the problem: https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/

Power Query is case sensitive, while the main Power BI engine is case insensitive. "As+", "aS+", "AS+", "as+" are the same values for Power BI. And if you have all of them in your data source and in Power Query then during data import into Power BI dataset they all will be replace by one of them. I think it will be the first one loaded into the dataset. If "as+" is the first loaded into the dataset, then all next "AS+", "As"+, aS+" records will be replaced with "as+". But it doesn't really matter what exactly you see in Power BI ("as+" or "AS+" or "As+" or "aS+"). For the datamodel (relationships) they are not different. For DAX comparison operators (e.g. "=") they are not different. While there are cases sensitive functions like EXACT(), you can't have values that are different only by case in one column.

[chwostian]

Avatorl, thank you for your answer. 

[PhilipTreacy]

Hi @chwostian 

Don't knwo why that would occur on its own.

Can you please supply your PBIX file?

Regards

Phil

[chwostian]

Hi Philip, I can't provide pbix file. The data is retrieved from AzureDevOps via analytics view. Any other suggestions? Thanks for prompt reply.