cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdenikeElemo
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.

2 REPLIES 2
AdenikeElemo
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.

amitchandak
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

Announcements
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