azure text analytics over requesting

[Anonymous]

I am testing the new service called azure text analytics.

there is a limit of 5000 request per 30 days for the free test account.

I have an Excel file with exactly 1000 rows of text.

When I use the script provided from the demo, I expect to use only 1000 requests from the free account.

but somehow I used already all 5000 free requests for only 1000 rows of text.

this does not make any sense at all!

below, the 2 scripts (sentiment and keyphrase) I am using on the same xlsx file, so my total should be 2000 requests and not 5000.

could someone please explain to me what is this issue???

(text) => let
    apikey      = "zzz",
    endpoint    = "https://brazilsouth.api.cognitive.microsoft.com/text/analytics/v2.0/keyPhrases",
    jsontext    = Text.FromBinary(Json.FromValue(Text.Start(Text.Trim(text), 5000))),
    jsonbody    = "{ documents: [ { language: ""es"", 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),
    keyphrases  = Text.Lower(Text.Combine(jsonresp[documents]{0}[keyPhrases], ", "))
in  keyphrases

.

(text) => let
    apikey      = "zzz",
    endpoint    = "https://brazilsouth.api.cognitive.microsoft.com/text/analytics/v2.0/sentiment",
    jsontext    = Text.FromBinary(Json.FromValue(Text.Start(Text.Trim(text), 5000))),
    jsonbody    = "{ documents: [ { language: ""es"", 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

 this is only one single refresh.

 

[JirkaZ]

Power BI is making the calls depending on whether you background data load is enabled for example. To see all the calls you should have your Fiddler running. Also part of the calls is due to the preview of the data being loaded and then once again when you hit close & apply.