Trigger Macro after all the Power Queries have updated

[10500438]

I have a power pivot model that has 10 queries, I have it set to refresh all when the workbook is opened. I have an Model Change event to save the workbook. Then a save event that triggers a macro to make a copy of the workbook with a timestamp.

I am trying to trigger a the event after ALL the power queries have updated in a single workbook. I have 10 queries and I am using the Model Change event, but as soon as the first query updates, it appears the macro is running. I tried using a VBscript through task scheduler, but it is triggering while the Model is still updating (it takes about 10min for the model to Refresh ALL).

I have worked on this for 3 days and I keep running into various issues. Is there a way to delay the Model Change event by 15min or something? Any suggestions are welcomed?

[AlB]

Hi @10500438 

Perhaps this would be of help?

https://community.powerbi.com/t5/Power-Query/Delay-web-query-until-condition-met-from-another-web-qu...

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[10500438]

I think I am trying to delay the vba from running until all the queries have updated. 

I know I can use Application.Wait, but I was hoping there was a way to determine the updating sequence of the queries and then use the last query updated to kick off the vba.

Any thoughts?