cancel
Showing results for 
Search instead for 
Did you mean: 

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
Community Support

@HelenaZorita 

 

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