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,

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

ibarrau thank you for your suggestions

I tried it in a Power BI Pro Workspace and it worked.

So according to https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads the "Offline Semantic Model Size" is max 3GB for a F8 Capacity. But I always thought this was just the Power BI file size and not the expanded model.


So how is the limit higher in a normal Pro Workspace?

And why am I paying thousands of bucks for the capacity when a normal pro workspace has higher limits?