Forum Discussion
Exceed Memory on Refresh
Hi I have a P1 Power Bi Premium capacity and the data set I am importing has a fact table coming from Snowflake that is 5GB with about 230m rows and 16 columns (3 years of data). The dim tables of w...
Hi ACSpotlight ,
Even if your dataset is trimmed to 2.8GB, additional memory is consumed by:
- DAX calculations
- Relationships and model metadata
- Query execution overhead
- Temporary storage during refresh
As pointed out in this thread,
https://community.fabric.microsoft.com/t5/Service/Power-BI-premium-capacity-memory-limitation-during-refresh/m-p/3957281
“You need twice as much memory as the size of the semantic model. The correct workaround is to implement incremental refresh and/or selective table and partition refresh"
This means you can try to
1.Implement Incremental Refresh
2.Simplify DAX calculations
3.Consider Gen2 Autoscale or Upgrade
You can try one of these menthods to avaoid hitting the error.
Hope this helps!
If the response has addressed your query, please accept it as a solution so that other members can easily find it.
Thank you.