Forum Discussion
Memory Error refreshIng fact able in dashboard - Power BI Desktop
Hi ,
I am getting below error when refreshing the DWH_ADJ(94,570,486 rows) fact table in Power BI Desktop.
Error details -
Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available.
the power BI version used is 2.146.705.0 64-bit (August 2025)
The error is specific to one dashboard and same DWH_ADJ refreesh is working fine in another dashboard.
Could you please suggest ot assist me with any solution for this issue
Reagards,
Bhaskar
Hello bhaskarpbi9999
ou can reduce the data in the datasource (Remove unused columns) and then reduce the original data by refreshing it. Or you can check only the desired tables when importing data.
In addition to reducing data, you can also optimize performance by optimizing the data model, optimizing the DAX writing, and so on.
Please refer to the following documents for more information.
Optimization guide for Power BI - Power BI | Microsoft Learn
Hi Idrissshatila
Thankand Kudos for your support. I will check the suggested solutions to see if it fixes the issues.
Regards,
Bhaskar
4 Replies
- IdrissshatilaSuper User
Hello bhaskarpbi9999
ou can reduce the data in the datasource (Remove unused columns) and then reduce the original data by refreshing it. Or you can check only the desired tables when importing data.
In addition to reducing data, you can also optimize performance by optimizing the data model, optimizing the DAX writing, and so on.
Please refer to the following documents for more information.
Optimization guide for Power BI - Power BI | Microsoft Learn
- bhaskarpbi9999Helper I
Hi Idrissshatila
Thankand Kudos for your support. I will check the suggested solutions to see if it fixes the issues.
Regards,
Bhaskar
- v-menakakotaCommunity Support
Hi ,
Thanks for reaching out to the Microsoft fabric community forum.Hi bhaskarpbi9999 ,
I would also take a moment to thank Idrissshatila , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
Thank you for the update. Once you’ve tried the solution, please reply back to confirm if the issue is resolved it could help other community members as well.
Regards,
Microsoft Fabric Community Support Team.