Forum Discussion

Anonymous

Not applicable

2 years ago

Solved

Text values are automatically and incorrectly reformated when loaded into model

Hi, I have a data quality analysis report on a payroll system. Data will be exported to a new HRIS soon so there is a renewed focus on improving data quality. One check is looking at text values ...

Ahmedx
2 years ago
refer to the following
1) The capitalization (uppercase / lowercase) of my text data changed in Power BI! Why?

https://www.dutchdatadude.com/some-of-you-might-have-seen-this-before-you-load-some-data-into-power-bi-and-suddenly-the-capitalization-uppercase-lowercase-of-your-text-changes-on-you/?utm_source=rss&utm_medium=rss&utm_campaign=some-of-you-might-have-seen-this-before-you-load-some-data-into-power-bi-and-suddenly-the-capitalization-uppercase-lowercase-of-your-text-changes-on-you

2)

https://blog.crossjoin.co.uk/2019/10/06/power-bi-and-case-sensitivity/

3)

https://xxlbi.com/blog/power-bi-antipatterns-12/

Icon for Resolver III rank

Resolver III

2 years ago

Wow! That is indeed crazy. Seems like there is also no easy workaround. Even if you add an "_" in front of each value you get the same issue.

What I do not understand is why this strange result is not also shown after running the Query in the Power Query GUI.