Solved: Unable to save changes made in Power Query Editor

Anonymous · ‎08-06-2021

Hi

I made some changes to an existing Power BI report within the Power Query Editor. Unfortunately, the server used for some of the queries does not respond, so I have to try again later.

To save my invested time, I would like to save the changes anyway. But this does not work. Once I choose "Close & Apply" in the Power Query Editor and one of the queries fails, I cannot "Apply changes", as Power BI then again tries to run the query - and again fails. So the cat it chasing it's tail...

How can I save my work?

Thanks

Christian

PaulDBrown · ‎08-06-2021

While in the Power Query, you can save the changes by clicking on the "save" icon. You can then close the query and when prompted, select "apply later".

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

View solution in original post

PaulDBrown · ‎08-06-2021

While in the Power Query, you can save the changes by clicking on the "save" icon. You can then close the query and when prompted, select "apply later".

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Syndicate_Admin · ‎03-07-2024

It turns out that they are not effectively saved, sometimes I make changes within Power query, close and save, but if it is canceled or the query fails, they are not saved!