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
This is very common issue these days. I would try below
1. Remove unused columns from Dataset
2. Try to agrregate table/query so that the count gets reduced
3. Try to reduce the date range if possible
Hope this helps... I will try to keep PBIX size<= 1 GB
