Forum Discussion
Multi-language report Power BI
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:
- 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.
- 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.
- 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.
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:
- Use the official Translations Builder tool to translate table names, column names, and measure names in the dataset.
- 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.
- If data must be available in multiple languages, add translation tables or localized columns and link them to the report.
- 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.
Thank you for all links. I will check the functionalities 🙂