Leila Etaati gets lost in translation:
There is a possibility to call cognitive service for translation inside Power Query.
I will use this to translate 3000 rows of data about people arrested in Iran for protesting; This information contains city Name, Fullname and Other statements.
In this article, I will show how to call cognitive services for translation, create a proper JSON call and finally, use it inside Power Query.
Read on for the translation in Power Query, specifically from Farsi to English.