Currency Formatting in paginated report

[nileshmore10]

Hello Everyone,

I hope you're having a fine day. I am dealing with a problem in the currency formatting in paginated reports using power BI Report Builder (previously known as SSRS - SQL Server Reporting System)

In the report, there are total 3 Matrices; which have similar columns. The column in question is 'Angebotsvolumen' which displays the 'estimatedvalue' from Dynamics 365 System. Now for this particular column, I have set the number format as German Currency:

Or the number format expression looks like this: #,0.00 '€';(#,0.00 '€')

The report works completely fine in the local Microsoft PowerBI Report Builder Tool. It displays the 'Angebotsolume' for example, one million Euros as 1.000.000,00 €

The Problem comes when I publish the report in a Premium Workspace in Power BI Service! When I generate the report from there, one million euros shows like this: 1,000,000.00 €

I already checked all the reginal settings of my laptop, Report Builder Tool, PowerBI Workspace Settings, personal office 365 Account settings, Browser Language Settings and what not...

Hence if anyone has any recommendation, suggestion, idea on how can I prevent this comma and fullstop exchange in PowerBI Service; I would be more than happy for it!

Thanks for your time for reading this post 🙂

[SolomonovAnton]

You're absolutely on the right track in checking all your local and cloud regional settings — this is a common issue when deploying Paginated Reports from Power BI Report Builder to the Power BI Service.

The root of the problem is that Power BI Service renders Paginated Reports using the service's locale, not your local development machine's settings, unless explicitly overridden.

✅ Solution: Set Language in Report Properties

To fix the decimal and thousand separator mismatch between Report Builder and Power BI Service, follow these steps:

1. In Report Builder, go to the menu bar and click Report > Report Properties.
2. Under the Localization section, look for the Language field.
3. Set the language explicitly to de-DE (for German/Germany).

This forces the formatting to use German regional settings regardless of where it's rendered.

<Language>de-DE</Language>

🔁 Also Check: Matrix or Textbox-Level Language

If the report still renders incorrectly, check individual matrix/textbox properties:

1. Right-click on the textbox displaying the 'Angebotsvolumen' value.
2. Select Text Box Properties → Number.
3. Set your desired currency format (as you've already done).
4. Then go to the ‘Language’ property in the Properties pane (View > Properties if not visible) and also set this to = "de-DE".

🧪 Test It

After setting the language on both the report and the textboxes, republish to Power BI Service and generate the report again. You should now see the correct German formatting: 1.000.000,00 €

📚 References

• Report Properties in Paginated Reports - Microsoft Docs
• SSRS Language Property (Microsoft Docs)

If you want help applying the language expression via code or need help checking the published version, just let me know!

✔️ If my message helped solve your issue, please mark it as Resolved!

👍 If it was helpful, consider giving it a Kudos!