Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Power BI Dynamic Language Translation.

Hi All,

 

Is there any way to change the language of the column name Dynamically depending on the country.

 

For Eg if an Chinese person login then automatically the column name should be dispalyed for them in chinese,If german or spain person login then it should be displayed in their own language.

 

Can you please help me on this please. 

 

 

 

Thanks

Vannikannan

11 REPLIES 11
Anonymous
Not applicable

Hi everyone 😉 ,

 

Here you find tool for reports (.pbix) translation - Power Translate! Very clear and easy to use, moreover the tool has been verified by MS AppSource.

 

Power Translate — an indispensable tool that will help you translate display elements (such as titles, headers, name of measures) placed in the Power BI created reports.

 

Here you can find also video with instruction - AppSource - Power Translate.

DidierTerrien
Advocate II
Advocate II

Hello,

Automatic translation of tabular model using Tabular Editor and Excel is possible since the Power BI team gave read/write access to the XMLA endpoint as a preview feature. So Power BI columns and measures can be translated this way. It works in the desktop and in Premium. For the moment, it doesn't work on the service because of Power BI service limitations.

Please watch this presentation video :   https://thebipower.fr/index.php/2020/04/12/automatic-translation-of-tabular-model/

Best regards

sheetalshettiga
Helper IV
Helper IV

Hi all,

 

    Is there any way to dynamically change headers of all columns to other language based on user login in different location and also the language of ribbon and dialog boxes.

 

when a user logs in to Power BI Service i want the users to view all the content based on the country language

Anonymous
Not applicable

I'm trying to solve this translation issue for an internal web application, which means that we have control over how the reports are built and what components in power BI desktop used. With these prerequisites, isn't it possible to handle the language using javacript ? I've just had a quick look at the DOM and done some simple tests and it seems like it could work. 

 

What I'm thinking of doing is for each component (table, slicer and so on) that we use in our reports I'll create some sort of selecter in javascript which extracts the values, i.e. for a table I'd extract the column headers, and pass them to my own translation service which returns the translated value and replaces the original value.

 

Someone must've thought about this before so I'm hoping if this is another dead end then someone who knows hopefully reads this and stops me. If not I'll probably move forward with this. If it works I'll try and package the solution so that other people embedding reports can use it

Curious how you went with this. Im currently looking at doing the same thing. 

Anonymous
Not applicable


@v-jiascu-msft wrote:

Hi @Anonymous,

 

Please refer to these workarounds below. Maybe you can create an idea here for this feature.

1. https://www.youtube.com/watch?v=jZQ4BZmtseo;

2. https://www.linkedin.com/pulse/how-create-multilingual-power-bi-report-proof-concept-emin-uzun.

 

Best Regards,

Dale


@Anonymous wrote:

Hi okje,

 

 

Kindly check the below link for the language translation.

 

https://www.youtube.com/watch?v=JJryD2dXVVw.

 

 

Thanks

Vannikannan.k

 


I'm trying to combine these two by following the Curbal video "Multilanguage Multilingual reports in Power BI" and the Bookmarks version from Emun Uzun's LinkedIn POC but I can't get it to work.

It all works up until I toggle between the bookmarks, the problem is that the Parameter (selected language parameter I created) does not change with the bookmark. 

Is this a known fault/not implemented function ? 

I'm trying to solve it this way since I don't want to duplicate my data (my data should not be translated, only column headers)

Anonymous
Not applicable

Hi Chris,

 

As of now the curbal video is the only workaround we have got for Dynamic language translation.

https://www.youtube.com/watch?v=JJryD2dXVVw.

 

 

Thanks&Regards

VanniKannan.k

v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

Please refer to these workarounds below. Maybe you can create an idea here for this feature.

1. https://www.youtube.com/watch?v=jZQ4BZmtseo;

2. https://www.linkedin.com/pulse/how-create-multilingual-power-bi-report-proof-concept-emin-uzun.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi Dale,

 

Thanks for Reply.

 

The link which you have shared me translate "Data" to different language,But I want to translate column names dynamically to different language.

 

For Example if I have an table name Sale when an chinese user login he should be able to see it in his own language "拍卖".

 

And even the column names in the dataset  should be translated to there own language.Then only we will be able to provide the SSBI to the end user.

 

Help me on this.

 

Thanks

Vannikannan.k

Hi @Anonymous,

 

Have you found a solution to translate the column names?

 

Thanks,

Ojke.

 

Anonymous
Not applicable

Hi okje,

 

 

Kindly check the below link for the language translation.

 

https://www.youtube.com/watch?v=JJryD2dXVVw.

 

 

Thanks

Vannikannan.k

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.