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
Share Improve this question edited Mar 15 at 14:36 Pratham Dhanesha asked Mar 15 at 14:26 Pratham DhaneshaPratham Dhanesha 465 bronze badges1 Answer
Reset to default 1For 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.