error returned there's not enough memory to complete this operation

[adityavighne]

Hi Everyone,

Anyone getting this error while loading data from SQL and Excel file. Kindly reply with solution.

I have already checked below things -

1. I'm using more than 8GB RAM laptop
2. Reinstall Power BI
3. Create new excel sheets
4. change settings while loading data
5. untick "Auto Data/time"
6. Unlock file before opening
7. 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

[v-frfei-msft]

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