Refresh powerpivot data connections using Power Automate desktop

gapa 1 Reputation point
2021-04-03T01:16:29.727+00:00

Hi there,

I have a power pivot table with multiple data connections that I set to refresh automatically when the file is open. Is there a way to use Power Automate Desktop to open the file and refresh the data connections on my behalf ? Or is there an easier solution that will not involve leaving the files open and setting the auto-refresh based on time ?
It's easy to set power automate to open the excel file, however the content is not updated.

Thank you.
George

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,773 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Miguel Escobar 326 Reputation points
    2021-04-03T21:58:45.17+00:00

    Hi!
    I'd suggest you post this question on the official Power Automate Community forum:
    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    For any other questions that are related to Power Query, you can use the Q&A forum.

    Best!

    0 comments