Failed to save modifications to the server. Error returned: 'There's not enough memory to complete

[dinoscool3]

Hello! Got a report that's giving me trouble! I've been using this report for about a month, worked fine. Last week, I was making some new changes to the table and soon after I started getting errors that I couldn't refresh becuase of not enough memory.

Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available. '.

I took a look in my task manager and sure enough I see my memory growing until it maxes out and the refresh stops after a few minute:

I've tried ot reverse changes I made, delete tables I wasn't actively using, anything, and nothing works. It appears to be centered around at least one table, but its the most important table I need. I have 16GB of memory and have never run into this before, even with reports that use far more data than these tables currently have.

Any ideas?

[dinoscool3 · Accepted solution]

I figured out the problem, there was a calculated column I had to check for the first instance of an item in one of my tables. For some reason it was causing the memory problem. Once it was removed I had no issues. Now I'll have to find a way to replace that column...

[v-xiaotang]

Hi @dinoscool3 

Thanks for reaching out to us.

please check if the solution in this post helps, Failed to save modifications to the server … not ... - Microsoft Power BI Community

"

I think the date table should not the root casing of your scenario. Have you turned off the 'relationship detect' options to disable auto detect the table relationships? 

Create and manage relationships in Power BI Desktop 

How many records are your data table hosted? Any complex expressions calculation(multiple iterators, nested cross table looping calculation ....) and advanced operation(merge, combine, reference, invoke custom functions, recursion...) existed in Dax or query editor side?

Optimizing nested iterators in DAX 

Recursive Functions in Power BI / Power Query 

AFAIK, they may affect the performance and spend a huge amount of system resources.You can also take a look at the following document about performance tips:

Optimization guide for Power BI 

”

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.