I got a similar issue. I work with Powerbi for a long time and suddenly the pending changes yellow bar does not work.
Pressing Apply Changes boots a Query Metadata popup that says that the data has been loaded and nothing happens
Pressing Discard Changes I get the same Parameter screen as "cristianml'
I can not refresh any cube! Its awful!
Loaded my back up projects and I get the same pop up even if I havenot made any changes in months. I think that the issue might be related with a Windows update since this started happening after I updated with the latest windows update
I have multiple reports using by Power BI desktop and one of .pbix file suddenly popup pending changes once I opened file by PBI desktop August 2022 (MS Store) version and it's unable to remove the popup by refreshing data and queries while the other .pbix files don't have any issues.
Lastly I tried to clear all caches and restart Power BI desktop, could eliminate this issue.
Having the same issue. Seems like a bugged version has been released. Among that the Desktop app takes a long time to perform small actions, has issues with loading data etc. Hoping for a quick patch.
I got it! There are "helper queries" in power query. Some have errors. I deleted all of the helper queries with little yellow exclamation points next to them and the box dissapeared! It seems prior versions of PBI tolerated helper queries with errors. Let me know if this works!
Following @Jay_Mitchel and @cdlawrence solution (thanks so much! 😊), I reverted back to the July version and this works! I can successfully refresh my data sets and publish as usual.
Hi @cristianml,
Please rollback to previous version of PBI Desktop. If you coundn't do that, please reach support engineer by support ticket for further help.
Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Docs
Best Regards,
Community Support Team _ Caiyun