Pendig changes: query metadata don't get updated

[MariaC]

Hello,

I have some Power BI Boards which I edit once a month within the desktop app.

When I opened the boards yesterday I got a notification, that there are some pendig changes that have not yet been applied.

When I select "Apply changes", Power BI updates "query metadata":

For a moment a green tick is displayed.

However, the message "There are pendig changes" remains and I can't refresh my dataset.

When I select "Discard changes" nothing happens at all.

Does anyone know what are the pendig changes about? We didn't make changes to the dataset since last time.

How can I solve the pending changes to refresh my dataset?

[Jay_Mitchel]

Hello all, 

This issue is due to the August release (which was automatically updated on 09/08). See another user having this issue: https://community.powerbi.com/t5/Desktop/August-Update-Issue/m-p/2693929

I reverted back to the July-22 version & my reports opened normally - without this issue.. 

Hope this is fixed soon. 

[cdlawrence]

I had this issue too.

Even though I was able to get the message to go away, I could not load the existing dataset into a new report nor open existing reports based on the dataset.

I uninstalled Power BI and reverted back to the July version and I'm back to normal. I can load existing reports again as well as connect to the dataset in a new report.

You can find previous versions of the desktop here:

https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive?tabs=powerbi-de... 

[Steven_007]

Ok i read on another post that they had a couple of parameters in power query that were causing the issue, i had a look at the 2 parameters my refresh was trying to up date and simply changed the value, refreshed and changed it back again and refreshed once more. This seemed to fix the issue for me. Good luck.

[QuynhDam]

Please any expert or Microsoft agent makes this clarify... Is this an bug? or new data structure/model requirement?

I did work around as advices but not fix the issue.

😩

[Maia_Jin]

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.

Here's the download link to 

• July 2022 version of Power BI Desktop - 64-bit

Hope this works for you too.

[v-yetao1-msft]

Hi @MariaC 

I am so glad to hear that your issue has been fixed with other users' suggestions . At present, there are many problems with Desktop in August, so it is recommended to use the Version in July first, and then use it after the problem is updated in August . 

Best Regards,
Community Support Team _ Ailsa Tao

[umutkoyun]

Yes, after August update it occurs.

I fix the issue : 

Edit Query ---> Refresh Preview some of them only. Never asked again... 🤞 I was lucky I guess )))

[INTEP]

I am getting crazy trying to find the problem during two weeks until I had found this post. I revert back also to the July version and works.

Unbelievable that Microsoft does not fix this problem until now, causing a lot of trouble!

Thanks for all!

[edhans]

This was fixed a week ago @INTEP in the last August maintenance release. No need to revert to July now.

[Jay_Mitchel]

Hello @edhans  can you link any confirmation that the issue was fixed? I am still experiencing this metadata issue on the August version today.