Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @10500438
Perhaps this would be of help?
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
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.