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

Announcements

Welcome to the Power Platform Communities
Your Invited to Keeping It Real with the Power Platform
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Refresh an excel file ...
Power Automate
Unanswered

Refresh an excel file automatically from sharepoint

(0) ShareShare
ReportReport
Posted on by crazy_user 7

Hi all,

 

I have an excel file in use, which is made with "power Query".

The file gets data from an SharePoint site.

It is stores on OneDrive.

 

Every time I open that file, I have to push F5 at first.

 

Is it possible, to update that file once or twice a day automatically?

(also if my computer is closed)

Categories:
Building flows
I have the same question (0)
  • PowerAppsWizard Profile Picture
    PowerAppsWizard 388 on at

    Hi,

    As far as I know it is not possible to refresh the power query within the excel file using power automate. You could reconsider your power query and reflect that query in a power automate flow instead, if it is only getting data from a sharepoint site or list it might be fairly simple.

     

  • crazy_user Profile Picture
    crazy_user 7 on at

    Hi,

    many thanks for your feedback.

    Well, in this case it will not work, as I use 3 excel files, which are connected to each other (all on power query)

     

  • crazy_user Profile Picture
    crazy_user 7 on at

    According this file, it seems also, that office script does also not support power query.

    excel - How to write an office script that executes a predefined query to load data into a sheet? - Stack Overflow

     

    Might it be a solution, to include power query in a makro and run that makro by power automate?

  • PowerAppsWizard Profile Picture
    PowerAppsWizard 388 on at

    I think makros cannot be triggered either by power automate. And excel scripts cannot execute power query... so I dont think a power query possible right now.

  • crazy_user Profile Picture
    crazy_user 7 on at

    tank you, I feared that.

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

News and Announcements

Welcome to the Power Platform Communities
Your Invited to Keeping It Real with the Power Platform

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 469

#3
11manish Profile Picture

11manish 364

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans