Forum Discussion
PowerBi Service changes Decimal- and Thousand- Separator
Hello everyone,
again another Decimal- and Thousand- Separator issue.
I have created a paginated report with report builder. In report builder I have created a table and Thousand-separator (dot) and decimal separator (comma) are shown as I wish. Once I publish the report to the Service, it changes dot to comma and vice versa.
I understand this has something to do with the regional settings. I have checked all the settings on my computer as well as my microsoft account and it's all set to 'German'. What do I have to do to get the right settings?
It also backwards the time by one hour when I publish.
Thanks for your help!
Lukas
I finally worked it out myself.
In the local settings menu in report builder I manually set every numbers Language to German.
Cheers,
Lukas
11 Replies
LukasR The time issue is likely where your tenant is located. In the Service, use the ? icon in the upper right and go to About to see where your tenant is provisioned.
I finally worked it out myself.
In the local settings menu in report builder I manually set every numbers Language to German.
Cheers,
Lukas
Hey Greg_Deckler ,
thanks for your answer. I've looked it up as you mentioned, but this is in Germany, too.
Cheers, Lukas
LukasR Hmm, looks like the tenant is UTC +1 which is Central European Time so not sure why it would go back an hour unless your local machine is set to UTC +2 which is, I believe, Central European Summer Time.
Hi LukasR ,
You can probably refer to the similar solved post for reference:
http://schoennie.blogspot.com/2018/11/thousand-separator-and-decimal.html
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello chenwu zhu,
unfortunately this doesn't help, either. I've got my system set to German. And when I modify the report in the report builder desktop app it shows the separators correct. Only when I upload to the service it changes them. Ironically it shows the separators in a power bi dataset correctly as well. Only the report is the other way around.
I've a premium workspace for the report and a pro workspace for the report. Are there different settings for the different workspaces?
Hi LukasR ,
Which language did you choose for Power BI Service? It determines the format of your reports. Please refer to the snapshot below and try to change it.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The problem is rely clear however if you set the regional settings for your country language (for me Dutch) then other reports that are still being made in Excel are being affected due to this. Because reporting names like for days are being converted in to the language (dutvh) which I have then in my settings while I actualle need to have in English. So in my opinion Power Bi has a flaw
