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

Hi Anonymous ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng