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, 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

am_nr's avatar
am_nr
Helper I
1 year ago

Hi v-prasare, thanks for confirming. Ultimately, I think this was the issue as I was getting the same problem just refreshing with the smaller (2GB) table. When the logs were cleared for the source database then the problem stopped and the PBI data could be refreshed again. I've accepted your comment as the solution, thank you.