Unanswered

Update Power query Excel

(0) Share

Report

Posted on by Mauricio_paiva

I can't find the solution anywhere.. I need Power automate every day to update the Power query that are in the Excel file.. which trigger and which commands do I have to put in the trigger to make it happen? I ask for help from colleagues

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

Sort by

VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

You can try calling a vbscript or a VBA macro that will do the refresh.

https://stackoverflow.com/questions/36902975/auto-updating-power-query-connection-via-vba

https://www.excelguru.ca/blog/2014/10/22/refresh-power-query-with-vba/

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

If you're not into vba etc, this only takes 2 clicks...

Was this reply helpful? Yes No
Mauricio_paiva 5 on at

Like (0)

Report
Copy link

Link copied!

Is there any way to create this flow through the cloud, or only through the desktop? Is there a specific flow to perform the update via the cloud?

Was this reply helpful? Yes No
Mauricio_paiva 5 on at

Like (0)

Report
Copy link

Link copied!

Is there any way to create this flow through the cloud, or only through the desktop? Is there a specific flow to perform the update via the cloud?

Was this reply helpful? Yes No
VJR 7,635 on at

Like (0)

Report
Copy link

Link copied!

In Cloud flows at first check if there is a Power Query connector for Excel. Earlier it had one for SQL but for Excel it was about to be released later.

If not then there is a thing called as Office Scripts which can be called from Cloud Flows.

This is where you can find out how to record and generate Office Scripts.

I will also tag @DamoBird365 who could help you in doing this via Cloud Flows.

Was this reply helpful? Yes No
UK_Mike on at

Like (0)

Report
Copy link

Link copied!

Im sure there are but I only use PAD to make the flows, occasionally using PA to schedule these desktop flows.
To keep it simple use those 2 actions I suggested then get PA to schedule the desktop flow every hour / day / week / whatever, job done.
Or, to refresh a workbook, send keys Ctrl + Alt + F5.
Im a keep it simple stupid guy 😀

Was this reply helpful? Yes No