Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Character "ß" changes randomly in Powerbi report

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: 

idWord
1muss
2muß

 

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: 

 

IDWord
1muss
2muss

 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

WordValue
muss5
muß5

 

but I see that:

Word

Value

muss10

 

Do you know how to handel with that? Can I deactive this function, so that I see same as in Database? 

 

Thanks a lot!

 

Status: New
Comments
v-chuncz-msft
Community Support

@Anonymous 

 

That works fine for me. You may try the latest version to recreate the report.