Schedule refresh in power query in excel

[Rahul_SC]

Hi all,

Is there any way, we can schedule our query refresh in excel power query ?

We have this option in power bi, in power bi serverice. However, I would like to know if there is any workaround with that we can schedule our power query refresh.

Thanks!

[Rahul_SC]

Hi All,

I found a way to schedule refresh in power query. It was in property option. But the issue is, our excel file needs to be open. It does not work when my excel file is closed. 

[v-kkf-msft]

Hi @Rahul_SC ,

Please try the Reports Controller or Windows Task Scheduler.

For more information, please refer to:

https://github.com/IvanBond/Power-Refresh/ 

https://stackoverflow.com/questions/60972868/is-it-possible-to-schedule-the-data-refresh-of-a-power-... 

Best Regards,
Winniz