Excel Refresh every morning

(0) Share

Report

Posted on by Sanskruti

108

Hello,

I have created a flow for my excel refresh.
First i have recored and created a script.
"

Sub RefreshDatasett()
'
' RefreshDatasett Macro
'

'
ActiveWorkbook.RefreshAll
End Sub"

This is my script.

But when i run script in the power automate flow it is showing me no item.

Do you have any idea why i'm getting this error?

Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Gematria 222 on at

Like (0)

Report

That looks more like a VBA Script/Macro, which is not the scripting that are referred to in this action.

You will need to use TypeScript to create a Script in any Excel workbook using the Code editor located in Excel -> Automate tab

Unfortunately, running a Refresh All function through Power Automate is not really supported. Most Queries cannot be refreshed through Excel Online either, so you would need to use Power Automate Desktop to initiate the Query refresh and a Cloud Flow to trigger the Desktop Flow each morning.

Was this reply helpful? Yes No
Sanskruti 108 on at

Like (0)

Report

Thank you for replying.
But i dont have automate tab.
Is there any other way i can refresh my dataset in excel using web power automate only?

Thank you.

Was this reply helpful? Yes No
Gematria 222 on at

Like (0)

Report

Can you see it in Options and add it to the ribbon there?

The only Data sources that Excel online supports for Queries are these:

https://support.microsoft.com/en-au/office/power-query-data-sources-in-excel-versions-e9332067-8e49-46fc-97ff-f2e1bfa0cb16

So in short, if your Query only uses data from inside the specific Excel file, then you should be able to achieve it through a Cloud Flow. However, if it uses other Data sources, then it is not possible.

A Script to update Queries in the specific Workbook would look something like:

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

Was this reply helpful? Yes No
Sanskruti 108 on at

Like (0)

Report

Unfortunately i dont have automate tab option.

Was this reply helpful? Yes No