Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I've created a query to pull data from cognitive API from Azure (following Gil's DataChant article). Now that I have the data analized, I want to break the connection with Azure, but remaing with the data (offline) because every time I do a query change, all data in all tables refresh again and it's consuming Azure queries (text recognition allows 5.000 queries per month).
I already did everything I could and results in ERROR. How can I break the connection with the query below without losing the data I've obtained?
(Source as table) as any => let JsonRecords = Text.FromBinary(Json.FromValue(Source)), JsonRequest = "{""documents"": " & JsonRecords & "}", JsonContent = Text.ToBinary(JsonRequest, TextEncoding.Ascii), Response = Web.Contents("https://westus.api.cognitive.microsoft.com/text/analytics/v2.0/sentiment?", [ Headers = [#"Ocp-Apim-Subscription-Key"= "xxxxxxxxxxxxxxxxxxxxxx", #"Content-Type"="application/json", Accept="application/json"], Content=JsonContent ]), JsonResponse = Json.Document(Response,1252) in JsonResponse
My api key was modified by xxxxxxxxxxxx to ask this doubt here.
Thanks in advance!
Solved! Go to Solution.
Hi @KarineLago,
Could you try disabling "Include in Report Refresh" for the query in Query Editor to see if it works in this scenario?
Regards
Hi @KarineLago,
Could you try disabling "Include in Report Refresh" for the query in Query Editor to see if it works in this scenario?
Regards
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |