Forum Discussion

am_nr's avatar
am_nr
Helper I
1 year ago
Solved

Memory issue after data table doubles in size

The main fact table in my PBI report has doubled in size (from ~2GB to ~4GB). It's now about 60,000,000 rows. When I try to refresh this table I get the error message: Failed to save modifications...
Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi am_nr, Apologies for missing you last comment.

     

    It’s possible the issue is coming from the SQL Server side. When Power BI refreshes, it pushes queries back to the database, so if SQL Server is already under memory pressure that can cause the refresh to fail. I’d recommend testing the same query in SSMS or to check for indexing or resource bottlenecks on the database.

     

     

    thanks,

    Prashanth

v-prasare's avatar
v-prasare
Community Support
1 year ago

Hi am_nr,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

 

 


Best Regards,

Prashanth Are

MS Fabric communty support

am_nr's avatar
am_nr
Helper I
1 year ago

Hi v-prasare, I haven't been able to resolve my memory issue yet but I'm beginning to think it's an issue with the database from which I read in the data, rather than PBI itself. Could this be possible? The database itself is having memory issues, which complicates matters.