Forum Discussion
Refresh Datasets on Different Schedule
Hello - I'm building a report and want to know if you can refresh data sources on different schedules.
I have 4 SQL data sources. Three need to be refreshed daily, and one weekly.
I have an Excel data source which needs to be refreshed weekly.
Is it possible to set up a refresh schedule (may via Power Automate? to do this?
Thanks!
ConnieMaldonado thru power bi service you cannot separate the refresh schedule, yes using power automate new async refresh API, you can refresh the different tables Enhanced refresh with Power BI REST API - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
2 Replies
- parry2kSuper User
ConnieMaldonado thru power bi service you cannot separate the refresh schedule, yes using power automate new async refresh API, you can refresh the different tables Enhanced refresh with Power BI REST API - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
- ConnieMaldonadoResponsive Resident
Thank you!