Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Multilanguage Report - Publish public

Hi there I have created a multilingual report using all available tutorials. I used both the translation builder and the data translation. I have a premium license per user and the report works pe...
  • v-ssriganesh's avatar
    v-ssriganesh
    1 year ago

    Hi Anonymous,
    You're very welcome!

    Great question! metadata translations (such as table and column names) from Translation Builder are stored in the model and automatically apply based on the user's locale in Power BI Service. However, since Publish to Web does not support locale detection, these translations will not work in public reports. Additionally, Translation Builder does not store translations in an accessible table, so they cannot be directly used in a slicer or bookmark.

    The best alternative is to manually create a translation table within your dataset.

    • If possible, copy the translations from Tabular Editor or the Translation Builder tool into a new table. Structure this table with translations for column headers, field names, and other metadata.
    • Add a slicer to let users choose their preferred language. Use DAX measures to dynamically switch text labels based on the selected language.
    • If applicable, create bookmarks for different language views so users can switch between them easily.

    Since Publish to Web does not support automatic locale-based translations, this manual approach is the most effective way to handle multilingual reports.

    If this helps, then please Accept it as a solution and dropping a "Kudos" so other members can find it more easily.
    Hope this works for you!
    Thanks.