Microsoft Translator Support?

Hi v-huizhn-msft,

Thanks for your support.

I read the blog post and tried to establish a connection by using the template DATACHANT is providing.

Unfortunately, I get the following error message when I fill in my Ocp-Apim-Subscription-Key: "A web API key can only be specified when a web API key name is provided". I am aware of serveral post discussing that issue but I still not sure what to do about it.

The function I am using to get the translater access looks like this:

let
    EmptyContent = Text.ToBinary("", TextEncoding.Ascii),
    
    Response =
        Web.Contents("https://api.cognitive.microsoft.com/sts/v1.0/issueToken",
            [
                Headers =
                    [
                        #"Content-Type"="application/json",
                        Accept="application/jwt",
                        #"Ocp-Apim-Subscription-Key"= TranslatorKey
                    ],
                Content=EmptyContent
            ]),
    #"Imported Text" = Table.FromColumns({Lines.FromBinary(Response,null,null,20127)}),
    Res = #"Imported Text"{0}[Column1]
in
    Res

The function to translate the text looks like this:

(textToTranslate, TranslateTolanguage) =>    
let
    URL = "https://api.microsofttranslator.com/v2/http.svc/Translate?appid=Bearer " & GetTranslatorAccessToken & "&text=" & textToTranslate & "&to=" & TranslateTolanguage,
    Response = Web.Contents(
        URL,
        [
            Headers = [Accept="application/xml"]
        ]
    ),
    XML = Xml.Tables(Response, null, 65001),
    TranslatedText = XML{0}[#"Element:Text"]
in
    TranslatedText

Apart from that, I already checked if my Ocp-Apim-Subscription-Key is valid by using http://docs.microsofttranslator.com/oauth-token.html#/ . So far the key is valid since I received the response code 200.

BTW the variable TranslatorKey is stored as a parameter in Power BI.

Do you have any suggestions?

Cheers,

Dom