Forum Discussion
Continued Contributorerror returned there's not enough memory to complete this operation
Hi Everyone,
Anyone getting this error while loading data from SQL and Excel file. Kindly reply with solution.
I have already checked below things -
- I'm using more than 8GB RAM laptop
- Reinstall Power BI
- Create new excel sheets
- change settings while loading data
- untick "Auto Data/time"
- Unlock file before opening
- Checked on different system
"failed to save modifications to the server. error returned there's not enough memory to complete this operation"
Regards,
Aditya Vighne
2 Replies
v-frfei-msftCommunity Support
Hi adityavighne,
The error can be caused by the dataset hit the limitation, if you are using Import mode, the .pbix file in service shouldn't more than 1G. See: File size limit increase to 1 GB . If it's DirectQuery, there is a 1 million row limit for returning data. See: Limitations of DirectQuery.
Please try to filter on query to limit less data returned, then republish the report to service and refresh to see if the issue occurs.
Regards,
Frank
- adityavighne
Hi v-frfei-msft,
Thanks for reply.
File size is not more than 1GB or 1million row.
filters on query are present already.
Also I checked with MS Power BI support team they are not sure about this error.
Thansk & REgards,
Aditya Vighne
