Automatic Refresh without opening the file

[sigamtr3]

Dear all,

I am very new on Power Query and sorry if I didn't find a clear response in my topic below.

I would like to know please if, in Power Query, is possible to schedule the refresh of a query every week (without opening the file) and then save the update file in a specific folder. If not, could you please give the best practise to achieve this goal? Maybe also using PowerBI?

Thanks in advance

Kind Regards

[v-eqin-msft · Accepted solution]

Hi @sigamtr3 ,

To myknowledge, if you want to set up automatic refresh, please learn scheduled refresh or OneDrive refresh in Power BI service.

Refer to

Configure scheduled refresh - Power BI | Microsoft Docs

Data refresh in Power BI - Power BI | Microsoft Docs

https://exceloffthegrid.com/auto-refresh-power-query/

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.