cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Pending changes in your queries that haven't been applied

Hi everyone,

 

I have the above message appear each time I load into PowerBI.  I have refreshed all queries within the editor and made sure to close/apply, but it seems like it doesn't stick.  I have been unable to get rid of this message for a few days now, and I'm unable to make any changes unless I go into the query editor (such as a name change of a selection).  This happened when I did not load any further data into the model, it just started appearing the other day when I logged on in the morning.  If anyone has any suggestions I would greatly appreciate it, as I can't start deleting steps to my data imports, because I've put a lot of man hours into cleaning up the data.

 

It also says that I need to install R script to use a visual every time I start PowerBI, but I do currently use any visuals that utilize R script, so I'm confused on both ends and don't know if they have any connection.

 

Thanks for any and all help!

 

 
1 ACCEPTED SOLUTION
Anonymous
Not applicable

I updated to the latest version and it seemed to correct any errors that were still persisting and not being applied.  I'm not sure what change came across in the update to solve the issue, but here we are.  

 

Thanks for all the help and hopefully updating will help any others having a similar issue!

View solution in original post

12 REPLIES 12
Anonymous
Not applicable

I updated to the latest version and it seemed to correct any errors that were still persisting and not being applied.  I'm not sure what change came across in the update to solve the issue, but here we are.  

 

Thanks for all the help and hopefully updating will help any others having a similar issue!

View solution in original post

mjantune
Regular Visitor

I found this solution by @Sebas2905. It's a pain in the ass to implement, but it seems to work.

 

https://community.powerbi.com/t5/Desktop/quot-There-are-pending-changes-in-your-queries-that-haven-t... 

 

I had the same problem and was able to solve the issue, but be aware!  You will have to recreate your relationships in the model and your calculated columns in the tables. It's not perfect, but it's a lot less work than rebuilding the report entirely.

 

 

I did the following:

 

1. I opened the file with the "Pending changes" issue and opened the Power Query editor

2. I opened a new power BI file and copied all the tables from the file with the "Pending changes"issue to the new file and loaded the tables in the new file

3. I deleted all tables in the Power Query Editor in the file with the "Pending changes" issue, except for my Measures table. I kept the measures table. So make sure all your measures are put in a measures table. Don't close the Power Query editor!

4. Open the Power Query editor in the new file and copy all tables (except for the measures table) back to your file with the "Pending changes" issue.

5. Close the Power Query editor in the file with the "Pending changes" issue and it will load all tables. The message should now disappear.


I'm having same issue after upgrading PBIRS to May 2020.

I removed R and Py Visuals. but still am keep getting this warning message.

Anonymous
Not applicable

I only recently had this issue fixed, it seems that if you update to the latest version of of PowerBI, it should fix any continued "Pending Changings haven't been applied" issues.  

If it still occurs after that, I would imagine that there's still some type of query not loading correctly.  Try to check for the updates and hopefully that works!

mjantune
Regular Visitor

I´m having the same issue. It started today (16-06-2020). The pending changes in your query haven´t been applied keeps appearing even though I apply the changes, and even though I haven´t changed anything in those queries.

 

it seems to be an issue of the last update, given that I'm not the only one having this problem.

SteveD2
Resolver I
Resolver I

I don't know if this is related to the issue but, I was working on a model today (13/6/20) and this error just appeared. Despite pressing the accept and discard buttons, the error message persisted. The problem was resolved when I discovered that a parameter I had to define the data source was set to refresh only. When I changed it to allow it to load the error disappeared.

 

Why the parameter set to refresh only is the mystery for me. 

Thank you @SteveD2 for sharing this.

Unfortunatelly is not my case because I don't have parameters in my reports.

Thank you.

juan_pablo
Helper III
Helper III

I'm having the same issue.

"There are pending changes in your queries that haven't been applied" doesn't goes away even after applying the changes.

 

(I don't have the R issue).

 

This started after April's update.

parry2k
Super User
Super User

@Anonymous did you turned on metadata features in the preview? For R script, did you installed custom visuals that use "R", uninstall these visuals.

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Thanks for the message,

 

This is actually a separate issue too, I do not have the remove button available when trying to remove a custom visual.Capture.JPG

@Anonymous click on dots to see removal option

 

image.png

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Anonymous
Not applicable

Yes, when I click on remove a visual option, it gives me the pane I posted above, which does not allow me to remove any visuals, but does allow me to select them.  I have the remove option in another file, but not this one for some reason.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors