"There are pending changes in your queries that haven't been applied" doesn't goes away

[juan_pablo]

Hi,

After April's update, some of my report appeared with the warning message: "There are pending changes in your queries that haven't been applied". I then click "Apply Changes", Power BI applies the changes, and few seconds later, the warning message appears again.

This doesn't affect the report (in fact, I didn't made any changes to the queries, the warning just appeared after the update), but it takes space on the canvas and it's annoying to always have that warning covering the top centimeters of the report.

Is there any solution to this? May's update didn't solved the issue.

[isalamat]

Just had the same problem with my dataset. Solved it by going to Transform Data, Refresh Preview - Refresh All. It ran a refresh on the tables and after Close & Apply the annoying message disappered. Hopefully this helps someone. 

[Ktoce]

Can you be more specific with steps? I can't get it to work. Thanks 

[isalamat]

On the top of the main screen you can see Transform Data option. 

When you select Transform Data, a new window will open up, it's called Power Query. On the top of the new window you'll see Refresh Preview option, and if you expand that option you'll need to select Refresh All. 

It will run a refresh for a few minutes and then you can select Close & Apply in the top left corner. This should fix your dataset. I hope this helps. 

[Shramana]

Hey, Thanks for the solution. The pop up disappeared as of now. Phew!

[matbau]

It worked for me as well. Thanks for the answer!

[MAJones]

This fix has also worked for me! Thank you!

[joseramirez]

I just encountered the same issue and your solution worked for me; thank you!

[Syndicate_Admin]

I have this error: ExecuteXmla failed with result

Feedback Type:
Frown (Error)

Timestamp:
2021-08-17T05:57:59.8752303Z

Local Time:
2021-08-17T01:57:59.8752303-04:00

Session ID:
459176b7-e7e7-4c87-8caf-85b86819fd54

Release:
August 2021

Product Version:
2.96.701.0 (21.08) (x64)

Stack Trace:
Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ExecuteXmla(String xmla)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.<>c__DisplayClass45_0.<ImageLoadDatabaseFromPbix>b__0()
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.OnErrorClarify(Action action, String clarification)
--- End of stack trace from the previous location where the exception occurred ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.96.701.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService","Error":"Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException - PFE_SYSTEM","MethodDef":"ExecuteXmla","ErrorOffset":"112"}

InnerException0.Stack Trace:

OS Version:
Microsoft Windows NT 10.0.19042.0 (x64 es-MX)

CLR Version:
4.7 or later [Release Number = 528372]

Peak Virtual Memory:
102 GB

Private Memory:
303 MB

Peak Working Set:
434 MB

IE Version:
11.789.19041.0

User ID:
0c9d0889-1e44-4e49-9ad9-acf00bc70fd6

Telemetry Enabled:
True

DPI Scale:
100%

Supported Services:
Power BI

[PeteD1302]

I am having this issue after installing the PBI 22 September 2020 Desktop 64bit update; this has not occurred with any previous update over the last 2 years or more.

No matter what I do the pending changes message will not disapear, and occurs with a desktop file whne it first opens, this messsage did not appear anytime while using the September PBI Update.

I also cannot delete any tables in the desktop as the changes must be applied first. I can add new tables.

[PeteD1302]

Hi PBI Community, Would appreciate some help here, the update for October 2020 has not removed the "There are pending changes in your queries that have not been applied". This is only occurring in some of my desktops, and only for tables that come from SQL data servers. Other desktops using the same SQL data servers do not have this Applied query.

I can add new tables from the SQL server but cannot remove and existing tables excpet for ones created by me from an excel source file from my local PC.

I did re-install the August 2020 version and the pending changes query does not appear, and re-appears with teh October 2020 version.

[Mikelg]

I had this same issue and I discovered that in my case the issue was directly related to Power Query functions that had "Enable load" hiddenly activated.

However, the hidden active state of "Enable load" of a function can only be deactivated when the function is "stale" (with the yellow triangle). If you click on "Refresh Preview" and the function reloads (showing the fx icon) then the "Enable load" option will be greyed out and appear as deactivated (no tickmark). I believe that this is a bug and that it remains hiddenly activated causing this issue.

I solved it as follows using the July 2020 version of Power BI:

1. Clicked on the "x" on the yellow warning bar that said "there are pending changes in your queries...", and take note of which tables its identifying as stale
2. Click on "Transform Data" to open the Power Query Editor
3. Right click on all "stale" functions and deactivate "Enable Load"
4. Close & Apply changes
5. Refresh Power BI Report & Save

Probably the cause of this bug is that these functions were originally tables which were later converted into functions (modifying the first rows of the M code) and preserved the "Enable Load" active status.

Enable load shows up as activated then the functions are in stale state

"Enable load" option appears greyed out when the function refreshes properly

[tjd]

Happening to me also with the June 2020 release.  Could we please get a fix for this other than having to "rebuild" our model?

[Anonymous]

I am having exactly the same problem. Is there any solution to this? I am able to ignore it, but am not sure if there are any "knock on" effects.  I can neither Apply nor Discard the changes.

[Anonymous]

@v-diye-msft , can we get another look at this issue? It would be nice to get some sort of workaround other than "rebuild your whole PBIX". This looks like a legitimate bug and most likely due to the "enhanced metadata" preview feature. Thanks!

[Sebas2905]

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.

[gampy]

This error may still occur in new desktop releases. In my case, this happened due to cross-references between two Queries. Query2 refers to the field Query1[Fileld_1] in calculations, and Query1 then gets the calculated [Fileld_2] from Query2. Getting rid of the cross-references, "Apply Changes" warning disappears. Apparently, this is a some kind of bug, because the link is a cross-reference, not cyclic, and all the queries work out without errors...

[Robertostaltari]

Had same issue. The offenders were two parameters. Added some text in the descriptions for both and applied updates. Now is fixed.

[juan_pablo]

Thank you @Sebas2905  for your answer, seems it could work for small reports. Unfortunatelly your solution is not an option for me, I have more than 50 tables and hundreds of measures. The report is linked with a gateway and that could break the configuration in the PBI service. So I prefer to wait for a more formal solution.

Thank you anyway 😉

[Sebas2905]

@juan_pablo : I understand. We also had to fix this issue in a report with almost 300 measures, 50 calculated columns and more than 30 tables. We had to do this, because it's a report which we've build for a client and we weren't able to apply any changes anymore in the report due to this bug. Support became impossible. It was a lot of work, but currently the only option. I hope a fix will be released for you soon, but keep in mind that it's possible that you will run into the same problem as we had, namely: not being able to apply any changes in the Power Query editor.

Good luck!

[parry2k]

Try following solution

Download the latest June 2020 build (version: 2.82.5858.961). If the issue still exists, try the following:

1. Click “Discard changes” on the yellow warning bar, and take note of which tables its identifying as stale
2. In the Power Query Editor, change the description for each of the “stale” queries with value something like “test”
3. Apply changes

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!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡