Language change in one Column

[rajendraongole1]

Hi 

I am getting one of the column data as text with two different languages. " English & chinese"

How can we convert that particular column data into single language " English"

review

图纸已经发给客户

data

enitity

Good

Customer voice

图纸

The above example column review is having two different languages as shown. have to get that chinese to english. 

Please suggest.

[JirkaZ]

@rajendraongole1 IMHO the only way is to use some translator API and invoke a custom function as a new column. But if it's a lot of data, you'll probably hit an API throttling limit.

[rajendraongole1]

Hi

It is having less amount of data and also that another language is coming on only one particular field.

can you please suggest how to get the api and call it in desktop?

if any video or links available please share i will go through it.

[JirkaZ]

@rajendraongole1 Here's the Google Translate API reference page. https://cloud.google.com/translate/docs/

Here's a thread discussing how to call REST API endpoints from PowerQuery: 
https://community.powerbi.com/t5/Desktop/API-Calls-from-column/td-p/568646

[rajendraongole1]

Hi

I didnt find proper information with success. 

Is there any other way to achieve this ? i am getting chinese language in only one field combined with english.

How to achieve it?

Regards,

Rajendra

[JirkaZ]

@rajendraongole1 You don't need to change language. You need to translate the content. So the only way is to use some public API to do that. Sorry, but you'll have to learn it or leave it.