Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
"With Premium Gen2 and Embedded Gen 2, the amount of memory available on each node size is set to the limit of memory footprint of a single artifact, and not to the cumulative consumption of memory. For example, in Premium Gen2 P1 capacity, only a single dataset size is limited to 25 GB, in comparison to the original Premium, where the total memory footprint of the datasets being handled at the same time was limited to 25 GB." - MS Docs
Does this mean I can have 10 models at 10GB where no single model should exceed 25GB - sounds unlikely?
Or there is an eviction/ceiling criterion I'm not seeing in the documentation?
Thanks
Solved! Go to Solution.
Hi @Anonymous,
Agree with your opinion.
In Power BI Premium Gen2, the datasets are gated by their individual total size rather than collective capacity.
For example, " In Premium Gen2 P1 capacity, only a single dataset size is limited to 25 GB, in comparison to the original Premium, where the total memory footprint of the datasets being handled at the same time was limited to 25 GB." - MS Docs
We know that in Power BI Premium Gen1 the maximum memory capacity of P1 Plan is 25 GB, in this condition you will not be able to load two datasets at the same time, say 20 GB and 10 GB. however, Gen2 applies the 25 GB limit to each dataset. Therefore, each resource (dataset, report, data stream) will be boxed up to 25 GB. The maximum size limit for a single dataset in Gen2 is different for different Capacity Nodes.
In the first generation of Premium and Embedded, memory was restricted to a limited amount of RAM used by all artifacts simultaneously running. In Gen2, there is no memory Limit for the capacity as a whole. Instead, individual artifacts (such as datasets, dataflows, paginated reports) are subject to the following RAM limitations:
A single artifact cannot exceed the amount of memory the capacity SKU offers.
The limitation includes all the operations (interactive and background) being processed for the artifact while in use (for example, while a report is being viewed, interacted with, or refreshed).
Dataset operations like queries are also subject to individual memory limits, just as they are in the first version of Premium.
For more, please see here .
Also, here's a YouTube video to help you better understand Power BI Premium Gen2.
Hope it helps,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous,
Agree with your opinion.
In Power BI Premium Gen2, the datasets are gated by their individual total size rather than collective capacity.
For example, " In Premium Gen2 P1 capacity, only a single dataset size is limited to 25 GB, in comparison to the original Premium, where the total memory footprint of the datasets being handled at the same time was limited to 25 GB." - MS Docs
We know that in Power BI Premium Gen1 the maximum memory capacity of P1 Plan is 25 GB, in this condition you will not be able to load two datasets at the same time, say 20 GB and 10 GB. however, Gen2 applies the 25 GB limit to each dataset. Therefore, each resource (dataset, report, data stream) will be boxed up to 25 GB. The maximum size limit for a single dataset in Gen2 is different for different Capacity Nodes.
In the first generation of Premium and Embedded, memory was restricted to a limited amount of RAM used by all artifacts simultaneously running. In Gen2, there is no memory Limit for the capacity as a whole. Instead, individual artifacts (such as datasets, dataflows, paginated reports) are subject to the following RAM limitations:
A single artifact cannot exceed the amount of memory the capacity SKU offers.
The limitation includes all the operations (interactive and background) being processed for the artifact while in use (for example, while a report is being viewed, interacted with, or refreshed).
Dataset operations like queries are also subject to individual memory limits, just as they are in the first version of Premium.
For more, please see here .
Also, here's a YouTube video to help you better understand Power BI Premium Gen2.
Hope it helps,
Caitlyn Yan
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous This just means that you can have a single dataset that is up to 25GB in size but you still have the limitation that all datasets present cannot exceed 25GB in size. So you could have a 24GB model and a 1GB model but if you tried to add an additional 1GB model that would exceed the limits.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |