Capacity nodes for Premium Gen2 (Preview) - P1

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.