Break connection and remaing with data (paste values)

[KarineLago]

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!

[v-ljerr-msft · Accepted 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