Forum Discussion
Helper I40MB Power BI file is consuming 3000MB memory in refresh
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,
Helper Iibarrau 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?
- ibarrau
Super User
I'm glad it worked. That fixes your problem and solves the question.
Regarding this concern, Capacity has different limits than PRO and different features. Lower capacities might have similarities with PRO and not necessary be better. With a dedicated capacity you have a lot of features. That's for sure. But at lower capacities you might have benefits like a storing more than 1 gb data model size but you have memory limitations rather than pro that will limit the storage data model size and single table memory instead the whole model. Paying for capacity should consider many details and not jusst the semantic model memory, there are a lot of benifits included and you could be using direct lake.I hope that make sense.