Multi Lingual column headers

[dia612]

Hello,

I have a requirement where I need to show Power BI Reports in multiple languages.

As that feature is not yet available in Power BI. I have tried a work around sol for me.

But I have an issue here.

I have same table with (client,clientno., licensetype..) columns in 2 DBs(lets say A&B)

I have written an sp in SQL in both DBs where depending on the country the column headers & data will be changed to that particular country language.

Like in A DB, the data will be in English

       in B DB, the data will be in Portuguese

Initially ,I created visuals with English lang using table in  A DB

Now when I have to change the DB to B to get the data in Portuguese.

It is showing ERROR :  Fix This.

I guess , Even though there are same columns but since the name is changeddepending on lang, the power bi is not recognising the columns automatically.

Is there any sol  for this???

[amitchandak]

@dia612 , refer if these can help

https://www.powerbi-pro.com/en/creating-multilingual-reports-in-power-bi/

https://community.powerbi.com/t5/Desktop/How-to-create-Multilingual-Report-in-Power-BI/td-p/599696

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

[dia612]

Hello @amitchandak,

Thankyou for replying.

I have tried the sols from the links you suggested.But I have table visuals in most of the reports.

There is no way to change the column headers with respective to the lang selected.

Is there any way to change the column headers dynamically like using a measure??? 

[V-lianl-msft]

Hi @dia612 ,

Refer :

https://www.youtube.com/watch?v=yBJr0sAc-m4 

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