Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Column text translation in PowerBi

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 b...
General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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