web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / << Beginner>> Refresh ...
Power Automate
Unanswered

<< Beginner>> Refresh all data excel power query and pivot in excel file

(0) ShareShare
ReportReport
Posted on by

Hi All,

I recently discovered power automate and I was wondering if it could make my life easier by automating refresh tasks that I have to perform every morning.

 

Every morning I have a series of excel files that need to be refreshed.

 

Here is a summary of my steps:

  • I open my excel file which is on a sharepoint;
  • I do data/refresh all (to update my data that have been processed with powerquery)
  • I refresh my pivots
  • I close my file

I would like to know if it is possible to do this automatically.

 

Thank you in advance for your help,

Fabrizio (beginner)

Categories:
I have the same question (0)
  • Paulie78 Profile Picture
    8,422 Moderator on at

    You could do it with a UI Flow, but honestly it would be easier (and cheaper) to do this locally with either PowerShell or VBScript as a scheduled task in Windows.

     

    I've written code that does this in the past. I could give it to you but probably not appropriate to post here as this is a Power Automate forum not VBScript/PowerShell.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard