Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Handling 8M+ Rows in Power BI Pro – Import Model Size Limitations and DirectQuery Timeout Issues

Hello, We are currently using Power BI Pro and working on onboarding reports that require semantic models to load 8 million+ records from our data source. Multiple reports will be created on top...
Need Help
  • v-echaithra's avatar
    v-echaithra
    8 months ago

    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.

v-echaithra's avatar
v-echaithra
Community Support
7 months ago

HI Anonymous ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Best Regards,
Chaithra E.