Forum Discussion
Elisa_Costanza
10 months agoHelper I
Multi-language report Power BI
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 ...
- 10 months ago
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.
lbendlin
10 months agoSuper User
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
10 months agoHelper I
Thank you for complete instructions 🙂