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/

Anonymous

Not applicable

2 years ago

I guess I will have to duplicate the invalid values in a new column in PQ so they are not corrected to the valid values. Ironically, increasing the data model size because of a feature intended to decrease the data model size. 🙃