Power Platform Community Forum Thread Details

I am trying to update, using Power Automate, an Excel file stored in my OneDrive. This file contains 5 queries connected to different OneDrive sources (TABLE1, TABLE2, TABLE3, TABLE4, and TABLE5), which I have combined into a new query called "COMBINED".

The issue occurs when I modify the data in one of the queries (for example, TABLE1) and then open the Excel file from the browser (Excel for the web). The data does not update automatically, and I get the following message:

"Data could not be refreshed: This workbook contains Power Query queries that use data sources which cannot be refreshed in Excel for the web. (Learn more... Send feedback). Open in the desktop app."

When I open the file in the desktop app and manually refresh the data (DATA -> REFRESH ALL), the changes are reflected correctly. If I then open the file in Excel for the web, the data appears updated.

To try to solve this issue, I have set up a Power Automate flow with a recurrence trigger:

{
  "type": "Recurrence",
  "recurrence": {
    "frequency": "Minute",
    "interval": 1,
    "timeZone": "Tocantins Standard Time",
    "startTime": "2025-01-22T01:00:00Z"
  }
}

Then, I run a "Run Script" with the following code:

function main(workbook: ExcelScript.Workbook) {
    // Refreshes all data connections in the file
    workbook.refreshAllDataConnections();
}

The problem is that, although the script runs successfully, the data is not updated in the online version of the file (Excel for the web). The changes only appear if I open the file in the desktop app and manually run "REFRESH ALL".

Categories:

Building flows