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.
+1. So far you've to set query's parameter "background refresh" to FALSE effectively blocking entire Excel application waiting for query to finish.
Ejaz Ahmed commented
The Last Refreshed Time is also not exposed!
Ernie Christiansen commented
I completely agree with this. It makes no sense to not have it exposed.
Totally agree !! I need the status result !!
I work with large companies and large queries, and this is really something I need to!
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.