Forum Discussion
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...
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
You can easily use Measure Killer to remove all unused column, this should give you some breathing room.
Hey, thanks for the suggestion. I don't think I need it in this case, but good to know such a tool exists!