Forum Discussion

Jeffbruin's avatar
Jeffbruin
New Member
3 years ago

Handling Power query refresh errors resulting from source file refresh

Good Day,   I am using power query to automatically pull data from 3 source files every 5 minutes.  These source files automatically update at different frequencies from our ERP system . When the p...
Need Help
BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
3 years ago

Hi Jeffbruin ,

 

Where does your ERP save the source files to? Would it be possible to use Power Automate to detect a change in file modification date then copy the file somewhere else to be used for Power Query?

 

Pete