Schedule refresh in power query in excel

Question

Hi all,&nbsp;Is there any way, we can schedule our query refresh in excel power query ?&nbsp;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.&nbsp;Thanks!

rahul_sc · Answer

Hi All,&nbsp;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.&nbsp;&nbsp;&nbsp;

v-kkf-msft · Answer

Hi&nbsp;Rahul_SC&nbsp;,
&nbsp;
Please try the&nbsp;Reports Controller or&nbsp;Windows Task Scheduler.
&nbsp;
For more information, please refer to:
https://github.com/IvanBond/Power-Refresh/&nbsp;
https://stackoverflow.com/questions/60972868/is-it-possible-to-schedule-the-data-refresh-of-a-power-query-in-excel-to-refresh&nbsp;
&nbsp;
Best Regards,Winniz

Forum Discussion

Schedule refresh in power query in excel

2 Replies

Related content

Schedule refresh

Power BI - Schedule refresh

Power BI Service Scheduled Refresh

Schedule refresh

Power BI Report Server Scheduled Refresh Bottleneck Problem