Forum Discussion
Incremental refresh
i am using premium P1 capacity, i need to archive data of around 500 GB ( 4 years data) during incremental load , would power bi be able to handle that much data?
Power BI Premium P1 should be able to handle a 500 GB dataset, especially with incremental refresh enabled to manage data loading efficiently. Power BI datasets are limited by the maximum model size allowed by the capacity. For Premium P1, the maximum model size is 100 GB per dataset. But, ensure your 500 GB of raw data will likely need to be reduced through data modeling techniques, such as summarization, aggregation, or filtering, to fit within the 100 GB limit.
1 Reply
Power BI Premium P1 should be able to handle a 500 GB dataset, especially with incremental refresh enabled to manage data loading efficiently. Power BI datasets are limited by the maximum model size allowed by the capacity. For Premium P1, the maximum model size is 100 GB per dataset. But, ensure your 500 GB of raw data will likely need to be reduced through data modeling techniques, such as summarization, aggregation, or filtering, to fit within the 100 GB limit.