Max Model size limit in Premium Gen2

[NewUser777]

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

[alohaes]

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?

[djurecicK2]

You're welcome @NewUser777 . I wish this was documented a little more clearly.

[djurecicK2 · Accepted solution]

Hi @NewUser777 ,

 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.

[NewUser777]

Thanks @djurecicK2 for confirming. Appreciate your help 

[blopez11]

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-al... as it might shed more light.

Thanks,

[NewUser777]

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. 

@blopez11 

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