Forum Discussion

bhaskarpbi9999's avatar
bhaskarpbi9999
Icon for Helper I rankHelper I
11 months ago
Solved

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

Need Help

4 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Icon for Super User rankSuper User
    11 months ago

    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

     Slow loading of new page - Microsoft Power BI Community

    running out of resources - Microsoft Power BI Community

    • bhaskarpbi9999's avatar
      bhaskarpbi9999
      Icon for Helper I rankHelper I
      11 months ago

      Hi Idrissshatila

      Thankand Kudos for your support. I will check the suggested solutions to see if it fixes the issues.

       

      Regards,

      Bhaskar

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        11 months ago

        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.