Column text translation in PowerBi

[Anonymous]

Hi,

I have a list of 1941 position titles (with other employee data), 122 of these titles are in Spanish and I need all to be translated to English.

Can anyone advise what approach would be best (aside from a very large if statement?) I'm new to PowerBI

Thanks in advance 

Katie

[Anonymous]

Hi buddy,

as far as i know, the DAX formulas can't do that for you.

But, maybe you can create on power query a function to access the google translate site, paste your spanish text and get the translation and paste on your table.

If you like to do, send me a few lines so we can elaborate.

Any questions, ask 😉

[Anonymous]

Hi 🙂 

Thanks for the quick response - that sounds like a great approach! I can't find anything clear on connecting to Google Transalte from PowerBi - is it using Microsoft Azure?

Could you advise on any thing I could look up that would help me start?

Thanks

Katie