Answered

Refresh web power queries from Office Script with workbook content

(0) Share

Report

Posted on by Watever

Since power query is support on the excel for the web on current workbook data. https://techcommunity.microsoft.com/blog/excelblog/new-in-excel-for-the-web-power-query-refresh-is-now-generally-available-for-sele/3300369

I wanted to refresh the query with power automate.

I have a flow that add data to the file and wanted this to be updated. It seems it's not possible to refresh it. The script will return success but doesn't actually refresh.

This is what my refresh script is :


function main(workbook: ExcelScript.Workbook) {
    let currentWorksheet = workbook.getActiveWorksheet();

    // Look at every named item in the workbook.
    workbook.getNames().forEach((namedItem) => {
        // Find names containing "Review".
        if (namedItem.getName().includes("DATA")) {
            namedItem.delete();
            console.log("DATA deleted");
           
        }
    });


    // Define Name data on workbook range on used range
    workbook.addNamedItem("DATA", currentWorksheet.getUsedRange(), "");
    
    console.log(currentWorksheet.getUsedRange().getAddress());
    workbook.refreshAllDataConnections();
    console.log("Refresh done");

}

My flow will run fine but the query is not refreshed.

Or is there another way to do it ?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Ellis Karim 12,122 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Watever,

"Unfortunately, refreshing a Power Query data connection in a script run through Power Automate is not currently supported: Troubleshoot Office Scripts running in Power Automate - Office Scripts | Microsoft Learn"

Refresh not fully supported in Power Automate

Office Scripts can't refresh most data when run in Power Automate. Most refresh methods, such as PivotTable.refresh, do nothing when called in a flow. Workbook.refreshAllDataConnections only refreshes when PowerBI is the source. Additionally, Power Automate doesn't trigger a data refresh for formulas that use workbook links.

Troubleshoot Office Scripts running in Power Automate - Office Scripts | Microsoft Learn

Script methods that do nothing in Power Automate flows

The following methods do nothing in a script when called through Power Automate. They still return successfully and don't throw any errors.

Class Method

PivotTable refresh

Workbook refreshAllPivotTables

Worksheet refreshAllPivotTables

Ellis Karim
Blog | LinkedIn | Bluesky

Was this reply helpful? Yes No
Watever 79 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, that explain the issue

Is there other function in Script that doesn't run in power-query ? other that data refresh ?

Was this reply helpful? Yes No