Autorefreshing power query data in excel on a weekly basis

[klehar]

Hi,

So this might not be a conventaional Power BI question but I would really appreciate any answers to the below question:

I have a power bi excel data source that is using power query(another uses pivot tables).

Power BI file auto refreshes from Powr BI service however the excel source doesn't autorefresh.

I want the excel workbook to autorefresh the data on a weekly basis without I opening the excel file

How can i do this?

[v-yingjl]

Hi @klehar ,

About auto refresh power query data in excel, you can try to use VBA script, refer:

1. Refresh Pivot Table Automatically when Source Data Changes 
2. Auto Refresh PivotTables & Queries 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[goncalogeraldes]

Hello there, do you have the gateway installed and configured? Please check this solution provided by @v-yuezhe-msft in another thread regarding a similar problem.

Hope this answer solves your problem! If you need any additional help please tag me in your reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
Thanks!

Best regards,
Gonçalo Geraldes