Forum Discussion

adeelnazir's avatar
adeelnazir
Helper I
5 years ago

How to create multilingual dataset in Power BI Embedded app

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

 

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

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    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/1478584

    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's avatar
      adeelnazir
      Helper I
      5 years ago

      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's avatar
        v-robertq-msft
        Community Support
        5 years ago

        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.