Multi-language report Power BI

[Elisa_Costanza]

Hi everyone.. I’m working on a Power BI report in Direct Mode connection with the datasource. The report has been embedded into a business web application. What they’ve asked me now is to create the report also in German. How can I create a multi-language report? What is required, and I’d also like to understand if the embedded functionality could conflict with this. Thanks in advance to everyone for the help.

[v-pnaroju-msft]

Hi Elisa_Costanza,

We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Elisa_Costanza,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Elisa_Costanza,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft · Accepted solution]

Hi Elisa_Costanza,

Thank you for the follow up.

Based on my understanding, Power BI’s built-in translation features, using the Translations Builder, cover metadata (tables, columns, measures) and report labels.However, they do not automatically translate data values. Translating actual text data requires preparing or mapping translations before loading the data into the report.

Please consider the following steps which may help to resolve the issue:

1. Handle data translations at the upstream or source level, which is recommended for DirectQuery. Add localized columns or create localized views (for example, English and German) in the database or ETL layer.
2. Handle data translations using translation tables in the model.Maintain a lookup table containing keys, language identifiers and translated values, and link this to the data so that visuals display the correct language. This can be driven by a language slicer.
3. Use Power Query together with Azure Translator to pre-generate translated columns for the supported languages, keeping in mind cost and privacy considerations.
   
   We hope that the information provided will assist in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

   Thank you.

[Elisa_Costanza]

@lbendlin @v-pnaroju-msft It seems that the shared functionality works well for translation, columns, measures, and tables. But how do you apply translation to data as well?

[lbendlin]

That's not really in the scope for the Power BI framework, it is more something you need to prepare upstream and then present to the user as needed.  If this is text data you could also teach your users to highlight the text, right click and then "Translate selection".

[v-pnaroju-msft]

Hi Elisa_Costanza,

Thank you for the update.

Kindly keep us informed after you have checked the functionalities.Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @lbendlin, for your response.

Hi Elisa_Costanza,

We appreciate your inquiry submitted through the Microsoft Fabric Community Forum.

Based on my understanding, Power BI reports do not automatically translate report metadata, labels, or data values. Multi-language support requires configuring translations at various levels and ensuring that the embedded configuration supplies the appropriate locale.

Please follow the approach below, which may help resolve the issue:

1. Use the official Translations Builder tool to translate table names, column names, and measure names in the dataset.
2. For text elements such as titles, buttons, or slicers, use a localized labels table or the Translations Builder so these elements update according to the selected language.
3. If data must be available in multiple languages, add translation tables or localized columns and link them to the report.
4. The web application can control the language by passing locale settings (for example, de-DE for German) or by relying on the browser’s language headers.

Additionally, please refer to the links below for further information:
Create multiple-language reports with Translations Builder - Power BI | Microsoft Learn
Add a language to a Power BI report in Translations Builder - Power BI | Microsoft Learn
Add a Localized Labels table to a Power BI report - Power BI | Microsoft Learn
Use best practices to localize Power BI reports - Power BI | Microsoft Learn
Configure embedded report settings | Microsoft Learn

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

Thank you.

[Elisa_Costanza]

Thank you for all links. I will check the functionalities 🙂

[lbendlin]

This is the latest guidance I am aware of

Building Multi-language Reports for Power BI in 2023 | Microsoft Power BI Blog | Microsoft Power BI

[Elisa_Costanza]

Thank you for complete instructions 🙂