topic Re: Resource Governing: The operation failed because of insufficient memory. in Service

Resource Governing: The operation failed because of insufficient memory.

Cobra77 — Thu, 18 Mar 2021 09:53:59 GMT

Hi,

What is the option or other to modify ? without having to go through a P2 ?

We Have P1 Premium.

The dataflow since SQL server : LOAD/IMPORT OK

the dataset import since dataflow or SQL Server , this message :

Resource Governing: The operation failed because of insufficient memory. If the dataset is hosted on Premium capacity/server, please consider upgrading the capacity to one with more memory or reducing the memory footprint of your operation. Additional information: Requested 26065080KB, Command Memory Limit 26065080KB, Database Size Before Command Execution 149320KB.
URI du cluster: WABI-NORTH-EUROPE-redirect.analysis.windows.net
ID d'activité: 1c346a7e-c460-4676-bba0-baacb6cb2da6
ID de demande: 5f2ca691-805f-683a-17d8-353c0c4250c8
Heure: 2021-03-17 17:53:40Z

we don t see usage memory info since

Gen2 Utilization Metrics

Thanks for your help.

Re: Resource Governing: The operation failed because of insufficient memory.

lbendlin — Thu, 18 Mar 2021 20:28:00 GMT

Gen2 utilization app template is now available. https://powerbi.microsoft.com/en-us/blog/premium-gen2-utilization-analysis-app-now-available/

Re: Resource Governing: The operation failed because of insufficient memory.

Anonymous — Thu, 22 Apr 2021 09:23:10 GMT

We are on Premium, P2, Gen 2 - and have latelly experienced the same error sporadically - sometimes refreshes come through, and most often latelly, they don't. The error message more or less confirms that we are NOT exceeding our memory quota -and the fact that the "Gen 2" promise is that enough resource will atumatically be allocated for not failing refreshes makes everything even more confusing...Sure, Gen 2 to is in "public pre-view" so it's "at your own risk", but it looks like MSFT has still some issues to resolve until GA (and I hope these are not just unsolicited attempts to push customers to a higher plan than they need...)

Re: Resource Governing: The operation failed because of insufficient memory.

lbendlin — Thu, 22 Apr 2021 12:42:24 GMT

What's your favorite error message? Ours is "This is likely a transient issue" with no further explanation. Refreshes always work on the desktop but fail sporadically in the service.