Microsoft Power BI Report Server - June 2017 GA (on-premises)
In IE11 Internet Options, i set the language to "German (Switzerland) [de-CH]". Example number for de-CH should be 9'999.99
But in the rendered website, the number format is as example 9.999,99 which is "German (Germany) [de-DE]"
I guess only "German" is used for the number formatting localization, the culture part "Switzerland" is ignored...
Which kind of report( power bi report, rdl or mobile report ) did you deployed to Power BI report server and you wanted to format it as German (Switzerland) [de-CH]?
It's a Power BI report. I deployed the report to the Power BI Report Server.
We have report readers around the world. Our headquarter is in Switzerland. I want that all users see the numbers formatted in their preferreded language and cultur, as it is defined in the IE 11 Internet Options under "Languages".
In Switzerland, the users have this IE 11 language settings: German (Switzerland) [de-CH]. But with this settings, the number format for de-DE is applied, not for de-CH. If I use other language settings, as example en-US, everyting works fine.
Same problems still exist with current version October 2017 On-Premise. Problem exists with Excel Online, Power BI Reports. Excel called natively on the same tabular model is displayed correctly formatted.
Many thanks for further investigations through MS.
Official answer from MS Premier Support at 18. january 2018.....
I know you have been already told that it is a limitation of Power BI.
Power BI product group have confirmed that this is a limitation of Power BI at this moment and hence this is a behaviour by design.
We do not have an ETA for fix to share with you at this point.
Also, we do not have any workaround to suggest.
I apologise for the delay and the inconvenience caused.
PS: Excel online still has the same issue (office online server)
Many thanks for the info, Daniel!
Fortunately, none of our users know how the formatting for de-CH should actually look like :-) Only programmers know that. So far I have no complaint from the departments because of the wrong presentation...
Update from MS premier support from 7. february 2018.....let's hope!!
"I have further escalated this. Though, it is not confirmed, PG is planning to release the fix April/May time frame. I believe , it will be fixed latest by May release of the Power BI release."
No good news for them moment.
Error is still included in the latest version of March 2018. Will ask Microsoft Support if the fix will come in May as suggested before.