Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Could anywan help me with the following: Assumption: I decide to buy Premium P1 SKU for all of my employees, and also, I need to buy three additional PRO licenses for developers (two of these will be in charge for the admin roles and one for the designer). What is my total model size capacity? 25GB + 1*3 GB = 28GB and the Designer will have 26GB on the Cloud? For the better performance can I combinate Power BI capacity P1 SKU and Premium Per User, what will be my total model capacity in that case 25GB + 3*10 = 75GB
Solved! Go to Solution.
You cannot add Premium and PPU licenses to get more capacity.
P1 has a memory limit of 25GB, but that is a relatively small model size. MS recommends the PBIX be 3GB or less for a P1. That is because it is compressed and can greatly expand into RAM depending on how many users are accessing it.
PPU has model limit of 100GB per model, which is vastly superior to a P1 or P2, but it requires every user have a PPU license to access. But once they have that, you can have dozens of 100GB models one or dozens of PPU workspaces. Very very powerful. But may not be cost effective for large organizations. P2 and P3 (and larger) capacities generally are better in those cases for a cost per user metric.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingPefect my friend, thanks a lot
Very good answer I am going to accept that as solution, but please could you give me a little bit more info. I understood first part of your answer very well, that I am limited on the 25GM with the combination the 3PRO licences and Permium Capacity P1. But I am not still crystal clear wiht the PPU. Is it mean that I cannot conmbinate PPU and Premium Per Capacity together? Because the PPU cannot share the content with the Premium Capacity? So it is better and cheeper to go with the P2 and P3 insted of PPU (example for more then 500 users)? Thanks
Premium is a per company capacity, and you can add as many workspaces to it as you want.
PPU is a per user license, and you designate a workspace as PPU. then, only PPU users can get in. Pro and Free cannot.
Once designated as PPU, then it runs with the limits on the page I gave you, which is usually far above what a P1 or P2 capacity could do.
PPU though is intended for small orgs that cannot afford Premium. Not always, but usually. If you have 500 users and you want them to all be PPU, that would be 10,000/mo. You could just get premium for that, and have both a few more features (Premium has a few API calls allowed via Power Automate and other areas) that PPU doesn't have, plus multi-geo is desired, etc. And then it doesn't matter if you have 500 or 5,000 users. There is no extra cost. Only your developers need a Pro license to publish reports.
The only case I'd see a company having both Premium and PPU is to set up a group of Devs in PPU workspaces for testing and development, so as not to impact the company Premium capacity, but it wouldn't generally be used for actual report distribution.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou cannot add Premium and PPU licenses to get more capacity.
P1 has a memory limit of 25GB, but that is a relatively small model size. MS recommends the PBIX be 3GB or less for a P1. That is because it is compressed and can greatly expand into RAM depending on how many users are accessing it.
PPU has model limit of 100GB per model, which is vastly superior to a P1 or P2, but it requires every user have a PPU license to access. But once they have that, you can have dozens of 100GB models one or dozens of PPU workspaces. Very very powerful. But may not be cost effective for large organizations. P2 and P3 (and larger) capacities generally are better in those cases for a cost per user metric.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting