Power Platform Community Forum Thread Details

im having the excels file used on power query, would like to refresh the file by using flow. unfortunatly im stuck in "Enable background refresh"

Reference video
https://www.youtube.com/watch?v=4Qoh9t_ZvqI&t=108s

Categories:

Using flows

@Wasfi Maybe it worth running VBScript...

' Create an Excel application object
Set objExcel = CreateObject("Excel.Application")

' Open the Excel workbook
Set objWorkbook = objExcel.Workbooks.Open("C:\Path\To\Your\Workbook.xlsx")

' Refresh all data connections in the workbook
objWorkbook.RefreshAll

Check the video tutorial at - https://www.youtube.com/watch?v=j3rjH626OxY

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.