Power Query: How to have a source file auto update

[calinorth]

How can I mkae a source file that auto updates into excel everytime there are changes made to the source file.

 

[JEC]

Power Automate could be helpful here

 

[calinorth]

please explain

 

[JEC]

There is not a direct method for detecting changes in files. The easiest way is via power automate, which can detect changes. Search for Power Automate cloud flows. (Check if you have access to PA first)

Forums | Microsoft Power Platform Community

Quickly search for answers, join discussions, post questions, and work smarter in your business applications by joining the Microsoft Dynamics 365 Community.

powerusers.microsoft.com

 

[calinorth]

There is not a direct method for detecting changes in files. The easiest way is via power automate, which can detect changes. Search for Power Automate cloud flows. (Check if you have access to PA first)

Forums | Microsoft Power Platform Community

Quickly search for answers, join discussions, post questions, and work smarter in your business applications by joining the Microsoft Dynamics 365 Community.

powerusers.microsoft.com

will do let me check this out