Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need to embed a Power Bi report in Microsoft Dynamics. This report needs to be in French or in English, depends on the prefered language of the user. The prefered language information is in MS Dynamics.
What is the best way to create multilingual report? Parameters? Bookmarks?
I would prefer not to create 2 PBIX reports to reduce maintenance and risk of errors.
The report also needs to be automatically translated in the language of the user, so no toggle button. A different URL would be great, there may be other options.
thanks for your ideas!
joel
I'm in the same boat as you with Power BI Embedded. The multilingual reports question was often raised on forum threads and some suggestions have been proposed though IMHO I feel none really met true globalization standards status. It's sad when we know that globalization issue has long been settled in .Net development with the ability to create .resx files in combination with Culture and localization parameters. Some initiative has been brought in a custom bar chart Power BI Visuals with the addition of localization parameters in capabilities.json and the creation of a stringResources repository containing related languages labels translation in separate .json files. That may be an interesting option to adopt in a near future as it avoids reinventing the wheel. Only adding a localization capacity... though I fear some would bark arguing that would involve re-writing the whole Power BI core infrastructure. So perhaps the main and foremost question to answer when you deal with multilingual reports and dashboards is what needs to be translated in first place. In a straight data visualization point of view, both English & French audiences should see the very same "visual" data display. That is a bar chart or column chart should display the very same "graphic" values, no matter if it's displayed to an English or French audience. Only "text labels" change. Some have brought the idea of using bookmarks in same reports but I felt that easily led to messy "hide n' seek" scenarios. I want to keep things clean. I then thought of simply cloning existing reports in same workspace - renaming them with an "FR" suffix attribute - using PowerShell cmdlets. This way both versions could share the same datasets. Then I thought of simply renaming column names in French "FR" cloned version using reusable M language query. Original English versions would remain clean you say? The problem is modifying column headers in "FR" reports would automatically create a new "FR" associated dataset on publish. That's not what I want. [Sigh...] So I feel all this brings me back to square one - which is decoupling versions in 2 separate environments. This may end up in a costly investment managing and synchronizing both environments. It's a shame considering the fact all this could have been long settled with localization similar to .Net environment. I'm opened to new suggestions but please spare resending same links. I've tried them and none were feasible as none ever came close to true globalization standards status. Thank you for your patience reading this post.
Hi @Anonymous,
What is the best way to create multilingual report? Parameters? Bookmarks?
Here are some links showing how to create multilanguage report with parameter:
Multilanguage Multilingual reports in Power BI
Creating Report With Multiple Languages
The report also needs to be automatically translated in the language of the user, so no toggle button. A different URL would be great, there may be other options.
Based on my research, I havn't found a valid solution or workaround that can achieve such a requirement.
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.