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.
15
votes
Ivan Bondarenko
shared this idea
5 comments
-
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.
-
Pedro
commented
Totally agree !! I need the status result !!
-
Anonymous
commented
I work with large companies and large queries, and this is really something I need to!
-
Anonymous
commented
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.