Embeded capacity consumed memory

[ThomasG67]

Hi,

I need help whith the Embeded capacity.
We have a Embeded capacity in A3. In the documentation A3 have 10 Go of memory.

Why do I get this error message when I reload the model ?

Data source error: Resource Governing: This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted. More details: consumed memory 5372 MB, memory limit 5370 MB, database size before command execution 4869 MB. See https://go.microsoft.com/fwlink/?linkid=2159753 to learn more. Table: Customer.

If someone has the answer. Because we have 10 Go of memory !!

[v-dineshya · Accepted solution]

Hi @ThomasG67 ,

Thank you for reaching out to the Microsoft Community Forum.

The Error "Consumed memory 5372 MB, memory limit 5370 MB, database size before command execution 4869 MB" means, your dataset was already using 4869 MB before the operation.
The operation like a model refresh or query needed 503 MB more. That pushed the total to 5372 MB, which exceeded the memory limit of 5370 MB.

The 10 GB in A3 is the total memory available, but Power BI reserves part of it for system operations. The actual usable memory for datasets is less than 10 GB. Each dataset is subject to per-dataset memory limits, which are lower than the total capacity. For A3, the per-dataset memory limit is around 5 GB.

please try below things to fix the issue.

1. Remove unused columns and tables. Use Power Query to filter data before loading. Use aggregations or summary tables. Avoid importing large text fields or high-cardinality columns.

2. Break the model into smaller datasets if possible. Use composite models or DirectQuery for large tables.

3. Try to move to A4 or higher, which has a higher per-dataset memory limit or consider Power BI Premium (P SKUs), which offer more flexibility and higher limits.

4. If you are reloading the entire dataset every time, switch to incremental refresh to reduce memory usage.

Please refer below links.

Capacity and SKUs in Power BI embedded analytics - Power BI | Microsoft Learn

Power BI Embedded Analytics Capacity Planning - Power BI | Microsoft Learn

how to fix visual has exceeded the available resource. - Microsoft Q&A

Set visual query limits in Power BI Desktop - Power BI | Microsoft Learn

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

[v-dineshya]

Hi @ThomasG67 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh