Forum Discussion
Max Model size limit in Premium Gen2
I want to know the max model size limit and below are the specs for Gen2 Prem capacity
| Capacity | Dataset | Dataflow | Export API | ||||
| Capacity SKUs | V-cores | Max memory (GB)1, 2, 3 | DirectQuery/Live connection (per second)1, 2 | Max memory per query (GB)1, 2 | Model refresh parallelism2 | Dataflow parallel tasks5 | Max concurrent pages6 |
| P1/A4 | 8 | 25 | 30 | 6 | 40 | 32 | 55 |
Hi Anonymous ,
Yes, the limit for a single model is half of the listed size (assuming you want to be able to refresh the data)
Refreshing the dataset - The second action is refreshing the dataset after it's loaded into the memory. The refresh operation will cause the memory used by the dataset to double. The required memory doubles because the original copy of data is still available for active queries, while another copy is being processed by the refresh. Once the refresh transaction commits, the memory footprint will reduce.
6 Replies
For a single dataset (model), it is 25 GB. But, that includes all memory needed to handle various simultaneous operations on the dataset (loading into memory, refresh, user interactions with report resulting in queries back to the model, etc.). Please see https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-gen2-what-is#dataset-memory-allocation as it might shed more light.
Thanks,
Thanks , I have also found in Premium gen 2 p1 that it don't require cumulative memory limits,
https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-gen2-what-is#refreshes
Premium Gen2 and Embedded Gen 2 don't require cumulative memory limits, and therefore concurrent dataset refreshes don't contribute to resource constraints.
Hence the question only the data model excluding the other operatons how much max data it should hold?
Also if I go by documentation and the statement -
Three separate actions determine the amount of memory attributed to the original dataset, which may be larger than two times the dataset size. The total amount of memory used by one Power BI item can't exceed the SKU's Max memory per dataset allocation. Then for every 1 gb there will be 2gb hence total max you can think of is 12 gb in P1
Hi Anonymous ,
Yes, the limit for a single model is half of the listed size (assuming you want to be able to refresh the data)
Refreshing the dataset - The second action is refreshing the dataset after it's loaded into the memory. The refresh operation will cause the memory used by the dataset to double. The required memory doubles because the original copy of data is still available for active queries, while another copy is being processed by the refresh. Once the refresh transaction commits, the memory footprint will reduce.
Thanks djurecic for confirming. Appreciate your help
You're welcome Anonymous . I wish this was documented a little more clearly.
Hi good day to you. I am also looking for the Gen2 specs specifically max concurrent pages per SKU but I am unable
to find it in the documentation. Could you please share where you found it?
