web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : QwQeN+IksXByu2HOePLni/
Power Platform Community / Forums / Power Automate - Power Automate Desktop / Excel Worksheet has po...
Power Automate - Power Automate Desktop
Unanswered

Excel Worksheet has power query not working.

Like (0) ShareShare
ReportReport
Posted on 5 Feb 2024 08:32:27 by MaiPhuocHoang 9

Hi Everyone,

 

I have an Excel file with power query to get and convert data form other source.

So normally, When I open the file, it would take me sometime to finish the query.

But when I open the file with power automate using Launch Excel, the query didn't start or run.

Even when I used Wait 10s.

 

So, is it an error or the excel file cannot run query when I use Launch Excel in Power Automate?

 

I have the same question (0)
  • Rajesh_G Profile Picture
    Rajesh_G 45 on 15 Feb 2024 at 10:42:38
    Re: Excel Worksheet has power query not working.

    Hello @maiphuong0599 ,

    Don't forget to add wait action after that to finish the refresh.

    And please accept that as answer. If that works for you.

    Thanks and Regards,
    Rajesh G

  • MaiPhuocHoang Profile Picture
    MaiPhuocHoang 9 on 10 Feb 2024 at 06:23:30
    Re: Excel Worksheet has power query not working.

    Thanks so much. 

  • Rajesh_G Profile Picture
    Rajesh_G 45 on 09 Feb 2024 at 12:31:48
    Re: Excel Worksheet has power query not working.

    Hello @MaiPhuocHoang ,

    As of my knowledge Excel file can't run query when you open it through Launch Excel Action.

    You may try using VBA : ActiveWorkbook.RefreshAll

    Write this code in workbook open Action, So that whenever you open the excel, the code will automatically run and it will refresh the Query even if you open the excel through Launch Excel Action.

    Thanks & Regrds,
    Rajesh G

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
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts
List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans