Forum Discussion
Memory problems - Power BI Capacity
Hi Flowy ,
Please note the A1 SKU limit on dataset memory:
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.
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.
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.