Get status of WorkbookQuery (Power Query) in VBA

Could you please consider possibility to add new property to object WorkbookQuery, that return status of query result. E.g. "N rows loaded", "Load to Data Model failed.", "Connection only".
Currently I do not see option to catch query refresh issue in VBA.

21 votes

Ivan Bondarenko shared this idea · Apr 27, 2017 · Flag idea as inappropriate… · Admin →

6 comments

An error occurred while saving the comment

Joe commented · November 9, 2020 2:11 PM · Flag as inappropriate

+1. So far you've to set query's parameter "background refresh" to FALSE effectively blocking entire Excel application waiting for query to finish.

Submitting...
Ejaz Ahmed commented · February 25, 2020 5:25 AM · Flag as inappropriate

The Last Refreshed Time is also not exposed!

Submitting...
Ernie Christiansen commented · July 11, 2019 4:02 PM · Flag as inappropriate

I completely agree with this. It makes no sense to not have it exposed.

Submitting...
Pedro commented · April 10, 2019 2:32 PM · Flag as inappropriate

Totally agree !! I need the status result !!

Submitting...
Anonymous commented · December 5, 2017 1:48 AM · Flag as inappropriate

I work with large companies and large queries, and this is really something I need to!

Submitting...
Anonymous commented · June 29, 2017 3:19 AM · Flag as inappropriate

I am also experiencing the same problem. I need to be able to reference the WorkBookQuery status result in a user interface I am building.

Submitting...