Permission for refreshAllLinksToLinkedWorkbooks

[BennK]

Hello,

I try to run a rather simple script to refresh Data I get from another worksheet.

function main(workbook: ExcelScript.Workbook) {
// Refresh all workbooklinks
workbook.refreshAllLinksToLinkedWorkbooks();
}

I get the Error back that User did give permission to refresh from external Links.
Is there any way to give that permission? The idea is to use power automate to write these datas from several different workbooks into one periodically to create a changelog.
It works if I manually hit "refresh" but as it is right now I cannot automate the process becasue without the line he will just keep the last known value, even if it changes in the actual linked sheet.

Thanks in advance.