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.
Hey Anonymous ,
can you pls tell more about the column which is taking approx. 500MB?
Is this a key-column? Meaning, do you need this one column for specific operations on the model?
There are a few existing techniques to reduce the model size, like disable the "Available In MDX" option (reducing the dictionary size - available by using Tabular Editor). Be a bit careful with that when using the data in Excel.
It seems you have many columns inside - most likely some of them are really heavy weighted.
8M rows is not that much, even for a Pro license.
Try to reduce the model size with known techniques.
Take a look on that...
https://data-mozart.com/how-to-reduce-your-power-bi-model-size-by-90/
Regards
Thanks sergej_og !
We are trying to follow best practices to reduce the size. Yes, it is a key column which is a transaction number
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.