Incorrect locale (regional number formating) when exporting PowerBI report to PDF

[sasok]

Hi,

I'm having the following situation:

- Published PowerBI dataset in a Premium-Per-User Workspace where the culture is set to "de-CH - German (Switzerland)"

- A PowerBI report with a live connection to the dataset

- The language in the PowerBI service set to "Default (browser)", the configured language in the browser (Chrome) set to "German/Switzerland"

The report shown in the browser is formatted correctly. The number formatting is correct according to Swiss-German locale (example of formatted number: 88'100.00).

After exporting the report to the PDF the exported PDF file has incorrect number formatting (US formating; example: 88.100,00).

How is it possible to controle the locale/regional setting in the exported PDF?

Best regards,

Saso

[rogernc]

Vote the ideia

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=93c447cc-14ce-ed11-9ac4-501ac5247b23

[rogernc]

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=93c447cc-14ce-ed11-9ac4-501ac5247b23

[v-xinruzhu-msft]

Hi @sasok 

Try to go into the Settings menu in Chrome and search for “Language”, and it’s not just the default display language that matters the order is also important. Moving “German/Switzerland” to the top of the list, then deleting cached images and files.

You can refer to the following link.

Fixing incorrect date formats in Power BI Report Server when using Chrome or Firefox – Random Procra...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sasok]

Hi,

I have this correctly configured in Chrome.

The display in the browser is correct.

However, when I export the report to PDF - the number formatting in the exported PDF is not correct.

It seems the "Export to PDF" does not pick up the settings.

[v-xinruzhu-msft]

Hi @sasok 

The function of exporting to PDF from Power BI Service have some limitation.It can't guarantee the exported PDF from the Power BI service will always match the exported PDF from a local Power BI Desktop file,you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-pdf?tabs=powerbi-service#gener...

Maybe you can try to export it from Power BI Desktop.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sasok]

Is there a way to control/fix the regional setttings of the exported PDFs from service?

Exporting it from Power BI Desktop is unfortunatelly not an alternative. The users only have access to the curated reports in the service. And the plan is to create subscriptions where the reports will be send to emails in PDF format...

[v-xinruzhu-msft]

Hi @sasok 

It seems that there is no way to achieve this for the time being.

Perhaps you can vote on this idea as an idea on the IDEA website

You can come up with ideas on the following websites.

Ideas (powerbi.com)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.