Forum Discussion

HMVGGM's avatar
HMVGGM
New Member
11 months ago
Solved

Memory error

Hi, We migrated from P1 to Fabric at F32. I am aware of the memory thresholds under Fabric. I have enabled the large dataset format. I find the memory error suprising because the dataset seems small...
Need Help
  • Shahid12523's avatar
    Shahid12523
    11 months ago

    Your dataset (1.1 GB compressed) expands much larger in memory during refresh, and on F32 the per-dataset cap is ~9 GB. Your refresh spiked above that, so it failed.

     

    Fix: optimize the model (fewer columns, lower cardinality, better data types, use dataflows/partitioning) or scale up to F64+.

pallavi_r's avatar
pallavi_r
Super User
11 months ago

Hi HMVGGM ,

Are you using any dax calculated columns, In addition to Shahid12523 suggestion, please change all calculated columns to measures. Because during refresh, calculated columns operation also takes places and that takes lot of memory.

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi