Forum Discussion
help : dataset refresh issue
Hi askme1217 ,
Thanks for reaching out to the Microsoft fabric community forum.
With large datasets, Power BI can use much more memory than the dataset size during refresh. Setting up incremental refresh and removing unused columns or large tables can help reduce memory use. If issues persist, consider upgrading your capacity.Power BI Incremental Refresh Documentation - Incremental refresh and real-time data in Power BI
Optimization Techniques for Import Models (VertiPaq Engine )-
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Power BI Premium Capacity and Limits - What is Power BI Premium? - Power BI | Microsoft LearnIf the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Sreeteja.
Community Support Team
Hi askme1217 ,
Are you using calculated columns or calculated dax tables? Can you try refreshing dataset after removing calculated columns and tables. Calculated column takes memory depending on power query transformation.
Hope you have taken care of unused columns, incremental refresh and inefficient relational modelling (exp. many-many).
Thanks,
Pallavi