PowerQuery Refresh All Connection Only Queries in one go

[JEB85]

Hi,

I have a mixture of connection only and linked queries. I can refresh my linked queries by going to Data ==> Refresh All.
Is there a way of refreshing all my connection only queries in one go or do i have to go in to them individually to refresh them?

Thanks

 

[severynm]

You might consider creating a VBA script to refresh only the queries you want by their names. It might be possible to solve it more elegantly through the query object model somehow, but that's beyond my current knowledge.

 

[RoryA]

Just out of curiosity, why do you want to refresh a connection only query specifically?

 

[JEB85]

Just out of curiosity, why do you want to refresh a connection only query specifically?

Hi, the connection only tables are being joined in other queries for lookups, occasionally there will be more data that is added to these connection tables

 

[RoryA]

They should refresh whenever called.

 

[JEB85]

I just tested that and it worked - I had no idea it worked that way until now, thanks!

 

[RoryA]

Glad to help.