Auto Refresh Excel Report with Power Pivot Data Model

Hi,Dan44 . I am glad to help you.
1. You can try to use Power Automate to create a new stream to periodically refresh the data in the Excel file
url:Get started with Power Automate - Power Automate | Microsoft Learn
Official Microsoft Power Automate documentation - Power Automate | Microsoft Learn

2. You can also try using VBA macros to automatically refresh the Power Query and Power Pivot data models instead of your original Office Script.

You can also go to other forums for more help:
url:
Welcome to the Excel Community - Microsoft Community Hub
Excel (microsoft.com)
Best wishes for solving your problem sooner rather than later
I hope my suggestions will bring you some good ideas.

If you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.