cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rajendraongole1 Regular Visitor
Regular Visitor

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 5
JirkaZ Regular Visitor
Regular Visitor

Re: Language change in one Column

@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 Regular Visitor
Regular Visitor

Re: Language change in one Column

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 Regular Visitor
Regular Visitor

Re: Language change in one Column

@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 Regular Visitor
Regular Visitor

Re: Language change in one Column

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 Regular Visitor
Regular Visitor

Re: Language change in one Column

@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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 207 members 2,122 guests
Please welcome our newest community members: