Forum Discussion

Elisa_Costanza's avatar
10 months ago
Solved

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 ...
  • v-pnaroju-msft's avatar
    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:

    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.