Specify memory usage for PowerBI refresh on query string / api

[MrHappyHead]

I am refreshing PowerBi datasets from PowerShell using the Invoke-PowerBIRestMethod cmdlet.

My URL is of the following form:

$processURL = https://api.powerbi.com/v1.0/myorg/datasets/{someGuid}/refreshes

I initiate the call using this syntax:

Invoke-PowerBIRestMethod -Url $processURL -Method Post -Body($datasetGUID)

We are encountering an error recently "Resource governing: This operation was canceled because there wasn’t enough memory to finish running it. Either increase the memory of the Premium capacity where this dataset is hosted or reduce the memory footprint of your dataset....."

My question is simply:

Am I able to specify a flag or query string that will allow me to specify the memory usage for a refresh so that we do not encounter this error?

[MrHappyHead · Accepted solution]

We've managed to work around the problem by modelling the data differently.  We were doing too much work in an M summary table and crossed a threshold over the last few days from working to non-working. Lessons learnt from our side.

[cassidy]

I've not read or heard of a way to force Service to use Memory in any particular way, especially after Premium Gen2.  It's likely doing everything it can to make room, including evicting things stored in Memory if possible.

Are you saying the error only occurs when you intiate refresh via API?  Or does it happen with scheduled and manual refreshes as well?

I'm very familiar with Resource Governing due to Memory and I can only suggest evaluating your Dataset carefully to look for reductions in Size and ways to increase Query performance.