Forum Discussion
Autorefreshing power query data in excel on a weekly basis
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?
2 Replies
Hello there, do you have the gateway installed and configured? Please check this solution provided by Anonymous 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 GeraldesHi klehar ,
About auto refresh power query data in excel, you can try to use VBA script, refer:
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.
