cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajendraongole1
Responsive Resident
Responsive Resident

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
Resolver IV
Resolver IV

@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

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

@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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors