View localized paginated reports in the Power BI service

APPLIES TO: Power BI service Power BI Report Builder Power BI Desktop

You can view paginated reports in your local or preferred language on the Power BI service. This guidance applies only to paginated reports with Power BI semantic models as a data source. There are prerequisites that you should follow to leverage this capability.

Prerequisites

License requirements for Power BI paginated reports (.rdl files) are the same as for Power BI reports (.pbix files).

Add translations to the Power BI semantic model: Translation Builder documentation

Get started

In Power BI Report Builder, you can create a culture-sensitive report by adding the translated label measures to an RDL dataset. You can then reference the translated labels by specifying expressions such as =First(Fields!Product_Sales_Report_Label.Value, "TranslatedLabelsDataSet") .

You can publish a paginated RDL report from Power BI Report Builder and view the report in the Power BI service by setting the language in the browser.

You can create a paginated report in the Power BI service and view the translated content on the service by setting the language in the browser settings, if your Power BI semantic model contains the translations.

Another way to view the translated version is to append the url with "?language=de-DE".

Here's the English en-US version of a sample report on the service:

Screenshot of the report in en-US.

Here's the German de-DE version of the localized report on the service:

Screenshot of report in de-DE.

Considerations and limitations

When publishing/uploading a report from Power BI Report Builder

  • You can overwrite the browser language by setting the Report.Language property to the desired language. For example, if Report.Language = de-DE, the report displays de-DE as long as the translations exist in the Power BI semantic model.
  • When the Report.Language property is set to an expression, the browser or Power BI language settings are not overridden. For example, the Report.Language property is set to a report parameter (Example: "=Parameters!SomeLanguageParameter").

Next steps