Auto Refresh Excel Report with Power Pivot Data Model

Hi all,

I have this Office Script which can be scheduled in Excel: 

function main(workbook: ExcelScript.Workbook) {
    // Refresh all data connections
    workbook.refreshAllDataConnections();
}

This works well when my Excel report has been created through Analyze in Excel, from a semantic model published in Fabric. The big issue is when I have reports are configured by pulling data through Power Query for a Power Pivot data model. The scheduled refresh of the above script will not exectute (but the script will execute if I manually run it).

I therefore tried to amend the script to first refreshes all data connections and then introduces a delay before refreshing the Power Pivot data model:

function main(workbook: ExcelScript.Workbook) {
    // Refresh all data connections
    workbook.refreshAllDataConnections();

    // Delay in minutes
    const delayInMinutes = 3;
    const totalDelay = delayInMinutes * 60 * 1000; // Convert to milliseconds

    // Give sufficient delay to ensure connections are being refreshed properly
    setTimeout(() => {
        // Refresh the Power Pivot data model
        workbook.getModel().refresh();
    }, totalDelay); // 3 minutes delay
}

This doesn't work either however.

I then thought it could be because of the prompts I get from my workbook of: SECURITY WARNING External Data Connections have been disabled. So I added the folder containing your workbook to the list of trusted locations in Excel (File > Options > Trust Center > Trust Center Settings > Trusted Locations). Nothing changed with this either. 

Is there any way to overcome this? All I need is a reliable way to shedule refresh Power Query in my Power Pivot enabled workbook.

Thanks in advance