Forum Discussion
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 perfectly in the Power BI service and also with the (non-public) published embed link. The problem starts with the public publish link. With this link, I can't figure out how to manipulate it to change the language of the report.
For the service I use the link snippets: language=it-CH and Guidbookmark
and for the non-public embedding I used: &language=it-CH&filter=languages/Language eq 'Italiano'
When I create the public link, none of the above works.
I am grateful for any ideas to get the report translated.
Many thanks in advance
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.
8 Replies
Hi Anonymous
This might well be a limitation when using Publish to Web. Here is a link Publish to web from Power BI - Power BI | Microsoft Learn
Hi Anonymous,
Thank you for reaching out to the Microsoft Fabric community forum.
Also, thank you GilbertQ for sharing valuable insights.
Building on what GilbertQ mentioned, this does seem to be a limitation of Publish to Web. Unfortunately, public links do not support language selection via URL parameters.As an alternative, you can use a language slicer or bookmarks within the report for manual selection.
If you find this information useful, please accept it as a solution and give it a 'Kudos' to assist others in locating it easily.
Thank you.Hello and thank you very much for your help!
So I tried to change the language with the language slicer and with that I can use the data translations. But is there any way to change the locale code, like “de-CH” or any other way to access the translation builders translations? Or is the translation builder not accessible for a publicly published dashboard.Hi Anonymous,
Thank you for testing the language slicer and for your detailed follow-up.Unfortunately, Translation Builder translations are not accessible in a publicly published dashboard. This is because Translation Builder relies on user authentication and locale settings, which only apply when a user is signed in to Power BI Service. Since Publish to Web does not support user authentication, it cannot dynamically apply locale-based translations like "de-CH".
- Since automatic locale detection is not possible, the best approach for Publish to Web is to use a language slicer or bookmarks to allow users to manually select their preferred language.
- As a workaround, you can create different Publish to Web links, each pre-filtered for a specific language.
If you find this information useful, please “Accept it as a solution” and give it a “Kudos” to assist others in locating it easily.
Thank you.
Hi Anonymous,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
