0

I have a Microsoft Form that saves to an Excel file in my OneDrive. I use Power Queries to manipulate the data. This works fine for when I need open the excel file on my computer and I can then refresh the queries, but when I open in excel online I get "External Data Refresh Failed". What I would like to do is create a power automate that will automatically refresh the queries and then import them into a database. I'm new to power automate so any help is much appreciated! TLDR: I need a power automate to automatically refresh power queries in an excel file located in my OneDrive daily

person1234568475
  • 37

1 Answers1

1

Power Query has been integrated with Flow -> Power Automate for while now.

https://powerquery.microsoft.com/en-us/flow/

Mike Honey
  • 2,632