

February 1, 2019

hi Guys,
i am refreshing few queries using button and code.
Sub RefreshAllOutputQueries()
Dim conn As WorkbookConnection
For Each conn In ThisWorkbook.connections
With conn.OLEDBConnection
.BackgroundQuery = False 'or true, up to you
.Refresh
End With
End If
Next connEnd Sub
And this is working fine but after code Power Query creates additional processes in my PC memory:
This is making my pc slow. How to get rid of them? Why Power Quert created them?
Best,
Jacek

VIP

Trusted Members

December 7, 2016

Hello,
Not a really an answer to why these tasks are created, but you can always kill them if they are not needed.
Br,
Anders

VIP

Trusted Members

December 7, 2016


VIP

Trusted Members

December 7, 2016

Hello,
I searched for the exe file and found this blog post, seems you get to live with it.
Question: does it behave differently if you run the .BackgroundQuery with yes parameter than with no parameter?
Br,
Anders


February 1, 2019

Hello Anders,
thanks.
Yes it is the same but refreshin time is faster or seems to be faster (and still goin in background).
I have even more mashupContainers now.
Question is if they will kill my CPU ?
If not how we can destroy it using VBA or some kind of PowerQuery process?
I read here on forum that you can add one query with "ZZZZZZ" (to be refreshed as last one) to cheat PQ and finish all queries so i did:
1. I added table with only one row called "ZZZZZZZ_PQ" and now i refresh also it as last one (PQ takes queries alphabetically)
2. It didnt change anything - still mashups shows up.
Best,
Jacek

New Member

June 4, 2021

Happened to me this morning too. Not sure what is happening with the Mashup. I run my refresh, all data is brought back but the Mashup.Container.Loader stays there. If I try to load the data again, I get an error that it doesn't work. I need to kill the mashup for the refresh to work a second time.
I'm getting my data from a website. Not sure if this is the problem. This is the first time I have a problem with Power Query not refreshing...
1 Guest(s)
