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 best (aside from a very large if statement?) I'm new to PowerBI

 

Thanks in advance 

Katie

General Comment
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • 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