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