Forum Discussion
Power BI cognitive services - Error: Endpoint (404)
Hi, I had a little question may be one of you had the same issue. I tried to use the Cognitive Services for PBI Text Analytics. I create a cognitive Service on azure and create a funktion in PBI. But then a error occure - I get the mesage: "Web.Contents failed to get contents from 'https://powerbianalyticstext.cognitiveservices.azure.com/' (404):". So May be one of you had an idea how to handle this issue.
I tried also to finde the "Ocp-Apim-Subscription-Key" - but I failed, If this is the missing link may be someone can help me to finde it :)?
The code for the fuction:
= (text) => let
apikey = " Insert your API Key here ",
endpoint = " Insert your Endpoint here ",
jsontext = Text.FromBinary(Json.FromValue(Text.Start(Text.Trim(text), 5000))),
jsonbody = "{ documents: [ { language: ""en"", id: ""0"", text: " & jsontext & " } ] }",
bytesbody = Text.ToBinary(jsonbody),
headers = [#"Ocp-Apim-Subscription-Key" = apikey],
bytesresp = Web.Contents(endpoint, [Headers=headers, Content=bytesbody]),
jsonresp = Json.Document(bytesresp),
sentiment = jsonresp[documents]{0}[score]
in sentiment
Best,
Kathrin
Solved the problem by myself 😄 wasn't so easy but it works. Problem was the wrong Endpoint which MSFT wrote in the endpoint row. The right one can be find under point 2 (Api console).
3 Replies
Hi KBO ,
Could you please try to post this request using other tools to verify if the endpoint and api key are valid? The sent endponint is similar like "https://<your-custom-subdomain>.cognitiveservices.azure.com" & "/text/analytics/v2.1/sentiment" based on this document: https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi-key-phrases#more-text-analytics-services
Best regards,Solved the problem by myself 😄 wasn't so easy but it works. Problem was the wrong Endpoint which MSFT wrote in the endpoint row. The right one can be find under point 2 (Api console).
