Forum Discussion

Lanceometer's avatar
Lanceometer
Icon for Helper I rankHelper I
1 year ago
Solved

40MB Power BI file is consuming 3000MB memory in refresh

Hi folks,   I have a Power BI report with a pretty big dataset. The fact table is about 22 million rows with 23 columns and some minor dimension tables. Pretty nice star schema though.   Howeve...
Need Help
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. You can consider two things here. First, try it on a shared capacity instead of the Fabric one. The pro limits are at data model size (1gb) or single table memory usage. Maybe you can go through that way. As an alternative you could consider mirroring the snowflake and build the data model at a lakehouse. That way you could be using direct lake for the connection to power bi without the need of a refresh.

    I hope that helps,

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
1 year ago

Hi. You can consider two things here. First, try it on a shared capacity instead of the Fabric one. The pro limits are at data model size (1gb) or single table memory usage. Maybe you can go through that way. As an alternative you could consider mirroring the snowflake and build the data model at a lakehouse. That way you could be using direct lake for the connection to power bi without the need of a refresh.

I hope that helps,