I have 5 power queries that I would like to trigger with vba and show the status of when thy have completed their update (not just started to refresh). Is it possible to capture the completion of each refresh and then show it on a sheet for example. This would also allow other users to use it.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Run and show status of Power Query Refresh
- Thread starter Mr Denove
- Start date
Sorry, I don't know enough about Power Query to know if that is possible and how you would do it with the QueryTable events.Now when I was asking about the error count, I was actually talking about the numbers in blue that are displayed in the Queries and Connections pane (pic provided).
Would it be possible to update the VBA to also show the queries errors, so it would include the 292 and 65 respectively.
I found Power Query: Trying to Extract Errors, but that is purely PQ and I don't know how you could get the error counts with VBA.
Upvote
0
Excel Facts
What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
