Text translation in Powerbi

[sujatakaran]

Hello community, Can anyone please help me with how to translate text in powerbi? I have data in below format: 

I was wondering if there is a solution available which could translate the text in english, evertime the data is refreshed.

BR

Sujata

[amitchandak]

@sujatakaran , refer these

https://community.powerbi.com/t5/Desktop/Power-BI-Dynamic-Language-Translation/td-p/404190

https://community.powerbi.com/t5/Desktop/Connect-to-Azure-Translator-Text-API-from-Power-BI-Desktop/...

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

https://community.powerbi.com/t5/Desktop/Translate-regional-language-into-English-from-a-column/td-p...

[sujatakaran]

@amitchandak thanks for these. Most of these are to translate the visula lables. The one solution that could be worked upon is the Azure translator API but the datachant site does not provide the pbit file openly.

Thanks for your reply 🙂

[v-deddai1-msft]

Hi @sujatakaran ,

Would you please refer to the detailed steps in https://datachant.com/2018/08/09/book-excerpt-translating-text-in-excel-and-power-bi-using-power-que...?  

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

Best Regards,

Dedmon Dai

[az38]

@sujatakaran 

no, there is no such option in Power BI. You need to do some ETL transformation with some third-party tool before data load to PBI