Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Failure to close and apply changes in Power BI desktop

I made some changes in the query editor and close and apply the changes in the Power BI dsktop, I received error message and I was unable to complete the apply changes. 

Error message: 
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.

Regular Visitor

Thank you. I have taken the necessary steps and I have just a copy of the file that I am working on. Before today, it refreshes in Power BI without any problems but today, I created 2 parameters and applied them to the queries in the advance editor. They were correctly done but I could not close and apply the changes in Power BI. I have since discarded the changes and the problem is still pending. If I publish the report to the service in this situation, I am not sure if I will be able to refresh the data.

Super User
Super User

@AdenikeElemo , try to increase the data cache management cache. Under File -> options & Settings -> Options 


Load Setting.png


Also, make sure enough RAM is free. Close the browsers taking up a lot of memory

Also, look at steps in power query, that are too complex, revert one or two.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors