Forum Discussion
rajendraongole1
Super User
6 years agoLanguage 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...
JirkaZ
Solution Specialist
6 years agorajendraongole1 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
Super User
6 years agoHi
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
- JirkaZ6 years ago
Solution Specialist
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.