Forum Discussion
Language change in one Column
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.
5 Replies
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.
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.
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
