Forum Discussion
Dataset - storage
Hi, Anonymous
When working with a large dataset of more than 70 million records like yours, you may run into issues due to the size limitations of Power BI Pro. The maximum dataset size for Power BI Pro is 1 GB. Make sure your data model is optimized. Remove unnecessary columns and rows, and consider summarizing data where possible.
Dataflows can help you preprocess and transform your data before loading it into Power BI.
If your dataset exceeds the limits of Pro, consider upgrading to Power BI Premium, which supports larger datasets and provides additional functionality.You can also use incremental refresh, as rajendraongole1 said. You can check the following links:
Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Anonymous
When working with a large dataset of more than 70 million records like yours, you may run into issues due to the size limitations of Power BI Pro. The maximum dataset size for Power BI Pro is 1 GB. Make sure your data model is optimized. Remove unnecessary columns and rows, and consider summarizing data where possible.
Dataflows can help you preprocess and transform your data before loading it into Power BI.
If your dataset exceeds the limits of Pro, consider upgrading to Power BI Premium, which supports larger datasets and provides additional functionality.
You can also use incremental refresh, as rajendraongole1 said. You can check the following links:
Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
Best Regards
Yongkang Hua
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.