Loading data from Power Query to model changes data (values)?

[PaulDBrown]

Good evening,

I have just noticed something is going on when loading data from Power Query into a model. There are some values which seem to be "harmonised" in the process:

Is there a setting I am not aware of which makes this happen?

Thanks.

[mwegener · Accepted solution]

Hi @PaulDBrown ,

look at this.

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

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[PaulDBrown]

@mwegener 

Thanks, Marcus. Interesting reading, though it does leave me with a certain uneasy feeling. I think I would prefer PBI to keep the data integrity intact and make the "hamornisation" optional.