How to create multilingual dataset in Power BI Embedded app

[adeelnazir]

I want to create a Multilingual Report with a multilingual dataset in Power BI.

I have a dataset with 3 types of columns.

1. Col1 - Fr - french
2. col2 - Nl - dutch
3. col3 - En - English

I've been watched the below videos to do so, both are helpful

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

By following the above tutorials I'm able to create a report, where I can change values based on language selection.

But in addition, I want to change columns & measures names as well based on language selection.

Let say I'm showing some columns in a table named as (Id, Question...) 

when the user selects french

• The table column names would be like (Id, Question...)

When dutch selected

• The table column names should be like (Id, vraag ...)

In short, I want Dynamically change the column name based on language selection.

Note: I need to show the power bi report in our web app, not on the Power BI service.

Please help,

Thanks

[adeelnazir]

I've been watched the below videos to do so, both are helpful

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

By following the above tutorials I'm able to create a report, where I can change values based on language selection.

But in addition, I want to change columns & measures names as well based on language selection.

Let say I'm showing some columns in a table named as (Id, Question...) 

when the user selects french

• The table column names would be like (Id, Question...)

When dutch selected

• The table column names should be like (Id, vraag ...)

In short, I want Dynamically change the column name based on language selection.

Note: I need to show the power bi report in our web app, not on the Power BI service.

Please help,

Thanks

[v-robertq-msft]

Hi, @adeelnazir 

According to your description and requirement, here’s a blog that was written by members of our team that can roughly meet your needs, you can take a look:

https://community.powerbi.com/t5/Community-Blog/Transform-report-language-based-on-buttons/ba-p/1478...

You can follow the Demo and explaination to create a pbix file according to your situation and try to embed it to your web app.

You can download the Demo pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[adeelnazir]

So the only solution is through Bookmark right?

can we do this dynamically because we have to write a lot of duplicate measures in different languages?

[v-robertq-msft]

Hi, @adeelnazir 

In this case, I don’t think Power BI can support you to achieve this at current.

You can go to the Power BI idea to post a new idea so that others with the same idea can vote for you. I will also vote for you.

Thank you very much!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.