excel - How to convert Russian Text of a column to English text in Power BI? - Stack Overflow

admin管理员组

文章数量:1391030

So in this scenario I'm stuck in a situation for a dataset where the comments are given in Russian text, I want to use it to be displayed in English language.

(Link of the dataset: )

The data is in column format.

I want to create a new column which will be in English translation of them. I manually tried to translate them but it was difficult for 14000+ fields.

Tried using Excel to convert the data using Translate API where initially it should be like this : but when entered in Get data > URL tab it shows in Unicode format

/?sl=ru&tl=en&text=%D0%A1%D0%BA%D0%BE%D0%BB%D1%8C%D0%BA%D0%BE%20%D1%87%D0%B5%D0%BB%D0%BE%D0%B2%D0%B5%D0%BA%20%D0%B2%20%D0%BD%D0%B0%D1%88%D0%B5%D0%B9%20%D1%81%D0%B5%D0%BC%D1%8C%D0%B5%3F&op=translate

which when taken forward does not come to help

Can use either POWERBI for this or Microsoft Excel. If anyone could help me, please ping me on [email protected]

#powerbi #problemswithpowerbi #powerquery #translateapi #russiantoenglishtranslation

So in this scenario I'm stuck in a situation for a dataset where the comments are given in Russian text, I want to use it to be displayed in English language.

(Link of the dataset: https://www.kaggle/datasets/kapturovalexander/consumer-sentiments-and-ratings)

The data is in column format.

I want to create a new column which will be in English translation of them. I manually tried to translate them but it was difficult for 14000+ fields.

Tried using Excel to convert the data using Translate API where initially it should be like this : but when entered in Get data > URL tab it shows in Unicode format

https://translate.google/?sl=ru&tl=en&text=%D0%A1%D0%BA%D0%BE%D0%BB%D1%8C%D0%BA%D0%BE%20%D1%87%D0%B5%D0%BB%D0%BE%D0%B2%D0%B5%D0%BA%20%D0%B2%20%D0%BD%D0%B0%D1%88%D0%B5%D0%B9%20%D1%81%D0%B5%D0%BC%D1%8C%D0%B5%3F&op=translate

which when taken forward does not come to help

Can use either POWERBI for this or Microsoft Excel. If anyone could help me, please ping me on [email protected]

#powerbi #problemswithpowerbi #powerquery #translateapi #russiantoenglishtranslation

• excel
• powerbi
• powerquery
• google-translate

Share Improve this question Follow edited Mar 15 at 14:36 Pratham Dhanesha asked Mar 15 at 14:26 Pratham DhaneshaPratham Dhanesha 4655 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

For your questions "can this be done in Excel", I believe the short answer is no. There is not a native translation service there, as you have noted. Moving that much data in/out piecemeal is obviously not reasonable.

Excel Power Query won't let you call a DLL or external code unless you write your own connector.

If you're going to be doing this often, then maybe it is worth considering writing a connector for Power Query (https://learn.microsoft/en-us/power-query/install-sdk) or an Excel Add-In that completes this step.

PowerBI is for visualisation and reporting. It does include some translation tools. If you're just interested in translating a large volume of structured data, however, BI is probably not the right tool.

Especially if this is a one-off task, I suggest you check the built-in GOOGLETRANSLATE() function in Google Sheets: https://support.google/docs/answer/3093331?hl=en . If you actually need to produce an Excel file or BI presentation afterward, you can export the translated data back to Excel and proceed.

For the sample data you posted, the translation formula is trivial in Google Sheets - see image below.

本文标签： excelHow to convert Russian Text of a column to English text in Power BIStack Overflow