cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Flowy
New Member

Memory problems - Power BI Capacity

I've a workspace assigned to a Premium capacity (A1) but refresh datasets is not working (before assigne a capacity it was working).

 

Erro de fonte de dados: 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 by doing things like limiting the amount of imported data. More details: consumed memory 2386 MB, memory limit 2360 MB, database size before command execution 711 MB. Learn more, see https://go.microsoft.com/fwlink/?linkid=2159753.
Cluster URI: WABI-US-WEST2-redirect.analysis.windows.net
ID da atividade: 522a4161-7c51-433a-bd39-dab4fc01fad8
Solicitar ID: e2b680d6-cb17-4ee1-f029-8a1be7c4c5de
Hora: 2022-09-06 16:46:41Z


1 ACCEPTED SOLUTION
v-yadongf-msft
Community Support
Community Support

Hi @Flowy ,

 

Please note the A1 SKU limit on dataset memory:

vyadongfmsft_0-1662529457603.png

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

 

Refresh is a background operation that can occur when two conditions are met:

  • There is sufficient memory
  • The number of supported concurrent refreshes for the Premium capacity is not exceeded

When the conditions are not met, the refresh is queued until the conditions are favorable.

 

For a full refresh, recall that at least double the current dataset memory size is required. If sufficient memory is not available, then the refresh cannot commence until model eviction frees up memory - this means delays until one or more datasets becomes inactive and can be evicted.

 

For more information, please refer to: Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

 

Please check if there is any remaining memory in the workspaces.

vyadongfmsft_1-1662529939990.png

 

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yadongf-msft
Community Support
Community Support

Hi @Flowy ,

 

Please note the A1 SKU limit on dataset memory:

vyadongfmsft_0-1662529457603.png

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

 

Refresh is a background operation that can occur when two conditions are met:

  • There is sufficient memory
  • The number of supported concurrent refreshes for the Premium capacity is not exceeded

When the conditions are not met, the refresh is queued until the conditions are favorable.

 

For a full refresh, recall that at least double the current dataset memory size is required. If sufficient memory is not available, then the refresh cannot commence until model eviction frees up memory - this means delays until one or more datasets becomes inactive and can be evicted.

 

For more information, please refer to: Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

 

Please check if there is any remaining memory in the workspaces.

vyadongfmsft_1-1662529939990.png

 

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

edhans
Super User
Super User

An A1 sku only allows for very small datasets - 3GB max. You generally need 2-2.5X the memory of your dataset so it can refresh. For a brief period in time your dataset is doubled in size as the old data isn't discarded until the latest refresh can be completely swapped in. That way you lose nothing during a failed refresh. That depends too on how much is swapped out via incremental refresh. The more you have in historical partitions, the less RAM it will take as those aren't swapped out during a refresh.

 

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

 

I am honestly not sure why it was working if it was previously Pro as that has a 1GB per dataset limit. Is it possible it was in a Premium Per User workspace - PPU? That has a 100GB dataset.

 

Regardless, a dataset nearly 3GB in size will not work well in an A1 capacity.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors