Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.