Translate Texts In Power Query by Google Translate API

In this video, I'll show you how to automatically translate customer comments from various languages into English using the Google Translate API in Power Query. Whether you're analyzing feedback from global customers or working with multilingual datasets, this tutorial will help you streamline the translation process directly in Excel or Power BI. I'll walk you through the entire setup, from obtaining the API key to integrating it with Power Query for seamless translation. Perfect for data analysts and anyone looking to enhance their data transformation skills!
Don't forget to like, subscribe, and hit the bell icon for more Power Query tips and tutorials!

0:00 Problem description
0:34 Google Translate API
1:32 Result of using API
2:41 Creating a custom function
4:10 Translate the texts by adding a new column
4:45 Translate the texts by transforming the columns