Forum Discussion
Max Model size limit in Premium Gen2
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.
Super UserFor 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