How to derive static tables from PowerBI queries without data connection

Hi there!

I got some problems to generate a static table from a PowerBI query (Azure Maps route directions API).

My query produced the expected result for a list of points (response contains : distance, travel time and polyline-points for a list of origins * list of destinations, specified by latitute/longitute point coordinates. Basically i want the same table, but without the live-data connection, because it triggers billing and can´t be deployed that way (Azure Maps primary API-key can´t be in a deployed version of the .pbix).

So i basically ended up with:

My script:

let
    apiKey =  "deleted" , //deleted for security reasons
    url = "https://atlas.microsoft.com/route/directions/json", // Azure Maps Route Directions API

    getRouteInfo = (queryString as text) =>

        let
            queryParams = [
                #"api-version" = "1.0",
                query = queryString,
                geometry = "true",
                routeType = "fastest",
                #"subscription-key" = apiKey
            ],

            response = Web.Contents(url, [Query = queryParams, ApiKeyName = "subscription-key"]),
            jsonResponse = Json.Document(response)

        in 

            jsonResponse

in getRouteInfo

Now the problem is - everytime i refresh the query or try to load it into my visuals, i trigger the query another time (and Azure Maps billing costs occur). I want to create a static table, but it isn´t possible by "copy entire table" -> .csv / .xls , because after unpacking the list, where the polyline data is stored, i end up with 10^6 rows or smth (fields "points_polylinie") and some data gets shredded.

I tried to simply copy it into a new table, but the data connection stays active and as soon as i delete the api-key (to stop billable transactions), the preview gets lost. So this approach also doesn´t work:

let
    newTable = (workplace_list as table) as table =>
        let
            azureQuery = workplace_list,
            azureToRecord = Table.ToRecords(azureQuery),
            recordToTable = Table.FromRecords(azureToRecord)

        in
            recordToTable
in
    newTable

Any hints?