Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a problem with the german word muss and muß.
I have a table in the MSQL DB with two columns the ohne column contains one id and the other column contains a word:
id | Word |
1 | muss |
2 | muß |
When I load this data in Power bi I am able to see in the data model both words as they are saved in the Database. But when I build my report, the table seems suddenly like that:
ID | Word |
1 | muss |
2 | muss |
So that if I don't take the Id in the visualizations, the calculations are wrong because powerbi handel two "different" words as one and make the calcualtion including the data of both fields. Example..
I want to see that in power bi
Word | Value |
muss | 5 |
muß | 5 |
but I see that:
Word | Value |
muss | 10 |
Do you know how to handel with that? Can I deactive this function, so that I see same as in Database?
Thanks a lot!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.