Translate other languages column data into english?

[rajendraongole1]

Hi All,

I have one of the column with data representing information with other languages. need to convert that column level data into a standard english. 

Is there any possibility to translate other language data into english for column level?

Kindly suggest.

Regards,

Rajendra

[Anonymous]

Hi,

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.

[PhilipTreacy · Accepted solution]

HI @rajendraongole1 

You could call the Google Translate API to make the translation.  By creating a custom column and then using Web.Contents to pass the Chinese text to Google Translate, it will return the English translation.

https://cloud.google.com/translate/docs/reference/rest

Regards

Phil

[TomMartens]

Hey @rajendraongole1,

if you know the foreign values inside the column in advance, you can create a lookup table.

If you don't know the foreign values in advance that you can consider leveraging text analytics features from the cognitive services:

Tutorial: Use Cognitive Services in Power BI (Preview) - Power BI | Microsoft Docs

You have to be aware that this can become somewhat costly.

Hopefully, this provides some new ideas. If you need more help with the lookup table, please provide a pbix that contains sample data but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link if you use an Excel file to create the sample data and share the link.

Regards,

Tom

[rajendraongole1]

Hi Tom,

Below is the snapshot , as we are getting one of the column with mix of english and chinese data. But we want to get the data in one language (English).  Please suggest if there is any process to get the comment column with single language?(i.e. , english)