Forum Discussion
Handling 8M+ Rows in Power BI Pro – Import Model Size Limitations and DirectQuery Timeout Issues
Hi Anonymous ,
Thank you for the update. The 1 GB compressed dataset limit in Power BI Pro is a hard limit and cannot be exceeded. Creating or distributing models across multiple workspaces does not increase the maximum size available to a single dataset. Excessive memory consumption from key or high-cardinality columns is primarily a data model design challenge, not something licensing alone can resolve.
For large, transactional, and memory-intensive models, the supported and scalable solution is Premium Capacity combined with proper model optimisation.Best Regards,
Chaithra E.
Hi Zanqueta
Thank you for your quick response.
Quick question regarding Option B of the recommended approach (Premium or PPU).
You mentioned that upgrading to Power BI Premium Per User (PPU) or Premium Capacity increases dataset size limits:
PPU: Up to 100 GB per dataset
Premium Capacity: Up to 400 GB per dataset
These options also provide larger memory allocations, longer query timeouts, and advanced features such as aggregations and hybrid tables.
Our question is about the practical implications when choosing between PPU (100 GB limit) and Premium Capacity (400 GB limit). Since our semantic model pulls data from transactional tables, we noticed that even applying a single filter on one field consumes around 440 MB of memory. This raises the concern that even with a 100 GB dataset limit, the memory usage could still grow significantly depending on cardinality and filter operations.
Given this, would PPU (100 GB per dataset) be sufficient, or would Premium Capacity (400 GB per dataset) be more appropriate for our scenario?
Additionally, could you please assist with a cost comparison between PPU and Premium Capacity to help us evaluate Option B?
Hi Anonymous,
Refer this Microsoft official documentation for all details you need. 400GB for premium is usually with the highest capacity SKU.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!! Proud To Be a Super User !!! |
To my understanding, PPU costs $24 per user, provides up to 100 GB of dataset memory, and offers storage that starts around 10 TB and can grow depending on the tenant, with 100 TB being the upper limit typically supported.
Premium Per Capacity (PPC) is priced based on the capacity SKU you purchase, and it supports up to 400 GB of dataset memory (on the highest SKUs) along with 100 TB or more of storage.
Correct me if im wrongAnonymous,
Seems right. You can use this microsoft licensing guide for better clarity.Couple of pointers:
1. All licenses (Pro, PPU and Premium Capacity) can be cheaper if your client/organization has already purchased licenses in bulk. Microsoft does provide every license with discounted price when purchased in bulk. For example, Pro license which costs $14 sometimes goes as cheap as ~$7.6. So, ask about this as well to your Power BI platform admin team.2. The type of license you take also requires a lot to do with how many users are using the dashboard. Even if you have a PPU license, free licensed users generally cannot view reports in a non-premium workspace. If the user base is large, I'll recommend premium capacity since you just need to pay for premium capacity and some pro licenses for developers while free licensed users would be able to view the reports.
IMO, PPU is best when you have cost constraint and need only certain premium capabilities for person with PPU license. Premium capacity is go-to for getting all premium features and when the user base is large.
Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Proud To Be a Super User !!!
LinkedIn