I am making an API call in a Fabric Data Factor (the Power BI Execute Queries API, to the Fabric Capacity Metrics data model).
The query works and returns the data as expected using a Paginated Report.
I want to use the API call to extract this data but I have hit the 4mb limit issue.
I have solved this by adding the accept-encoding = gzip to the header of the API call.
The problem is, I do not know how to then take the resulting gzip file, and uncompress it back to its original JSON format to then load this data into my Warehouse.
Any suggestions appreciated.