question

gapa-4315 avatar image
0 Votes"
gapa-4315 asked MiguelEscobar-3907 edited

Refresh powerpivot data connections using Power Automate desktop

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-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MiguelEscobar-3907 avatar image
0 Votes"
MiguelEscobar-3907 answered

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!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.