This post is also available in:
Deutsch
For a while, it was only possible to provide a Power BI report in multiple languages using workarounds. Recently, the enhanced dataset metadata has made it very easy to change the language of a report in Power BI, making it multilingual, for example in German and English. Since the Power BI September Update, the enhanced dataset metadata is now the standard for metadata, upgrading a Power BI report almost to the level of an SSAS Tabular Model.
Enhanced dataset metadata enables SSAS Tabular functionalities
One of these new capabilities is to offer the data model of each Power BI report in multiple languages.
The easiest way to maintain multiple languages is currently using Tabular Editor. As an example we use the following simple report based on the Adventure Works database:
And the tables to be translated:
Once the Tabular Editor is installed, it can be started under “External Tools” with connection to the open file:
Maintaining translations in the Tabular Editor
In Tabular Editor we see the folder “Translations” at the very bottom, where we are able to create a new language for our data model by a click on the right mouse button:
We can then store the translations for every existing table:
Or also the name for each column:
Or also a measure:
We can recognize already translated tables by the blue background color of the text. After saving, the values are already available in the opened Power BI file.
Display in Power BI Desktop via language selection
To display the new language now, we have to change the application language to our target language, here German. We can do this in Power BI under File and Options:
After a restart of Power BI Desktop the report appears in the desired language:
The tables and columns are now also displayed in the new language translation:
Only the automatic date hierarchy is still created in English. I have not yet found a solution here either. If you have a tip here, please write it in the comments.
Display on the Power BI Service / powerbi.com
On the Power BI service, the report can also be displayed in a translated language. For this purpose, the display language must be set to the corresponding target language in the settings:
Theoretically the report should now be displayed in German, but in my case the report switches back to English after about 0.5 seconds. Also different browsers including in German language showed the same result here. Possibly the language of the operating system is used in this case. If you know more about it, feel free to write it in the comments.
DAX Code stays unchanged
It is important to mention that only the names of the individual tables and columns are displayed in the translated language. The actual names in the data model remain unaffected. This is clearly shown by the Dax formula of our average sales:
As soon as we go to the formula of the now translated field “Durchschn. Verkauf” we see the formula for “Average Sales”. This measure accesses the column “SalesAmount” of the table “FactInternetSales”, which now matches the column “Umsatz” in the table “FktInternetSales”.
A development in the translated language is unfortunately not possible, the DAX Interpreter cannot deal with the translated column names:
This is simply to illustrate how confusing translations could become during development. For end users this is a feature that has long been expected and needed, developers should continue to access the original language of the report.
is it possible to use it on dataflows ?
Hello Karim,
I guess you want to do the translation directly in the dataflow?!
As far as I know this is not possible, but I will take a look in the evening.
You can for sure import the Dataflow table to the data model and then translate it as part of the data model.
Best regards
Denis
Hi,
The same happens to me. In the service, after 1/2 second the report language changes to default language. Or to en-US if defined. While in desktop is working propertly…
Any ideas?
Hello Guys, have you figured out how to fix this problem as the same happens to me (browser and windows in French but it is displayed in en-US)?
Thanks in advance
Hey Seb_ABZ and Ricard,
no, unfortunately I also couldn’t make it work.
I also changed the language of Windows, changed the browser, but still the language changes back to English after half a second.
I will try to get some more eyes on that. Will write back when I have an update.
Best regards
Denis
Thanks Denis, this is helpful information! Do you know if it’s possible to use enhanced metadata on individual visuals (say, for example, if the report developer renames a field)?
Hey Grady,
thanks for reaching out. As far as I know the enhanced metadata is only affecting the underlying data model. For example the option to have multiple languages, to refresh only specific tables, use the XMLA endpoint features etc.
As the name says, the visuals are part of the visualization. If in this case a report developer changes the name for a specific column in a visual, I cannot imagine that it will affect the underlying data model as the change is only local in one specific visual. From my point of view there cannot be a change, but I’m not 100% sure as that’s my understanding.
Best regards
Denis
Hi , I do the same things in tabular editor but neither Power Bi Desktop or Service works translation to different language . However ,it automatically translates it to en-US .
Did you find a solution?
Hey John,
I’m not sure if I understood the issue correctly.
Power BI is not doing any translation. You have to create the traslations and maintain hem yourself.
Does that help?
Best regards
Denis
Hi All,
Is there any way to change the Language of the power bi report depending on the cuntry.
For Eg If an chinese person login then automatically the report displayed for them in chinese.if German or spain person login then it should be displayed in their own language.Data should be visible in their own langauge.
Hey Nagaraju,
first thing, I realized the translations only work in premium or premium per user workspaces.
I don’t know any possibility to do that automatically. Power BI is simply taking the language you put in your settings.
If a person from China is setting the language to English, then always the English version will be shown. Same for people from Germany or Spain.
I think if you want to really do it based on the country, then you have to create a user table, check the country of the logged in person and apply that, probably with RLS. But that’s quite a lot of effort. I personally would let the choice to the person and make them aware that they can change the language settings.
Hope that helps.
Best regards
Denis