Forum Discussion
Refresh reports connected to one datamart with different schedules
Community SupportHi, MariiaTeteriuk
One potential solution could be to use Power Automate (formerly known as Microsoft Flow) to trigger the refresh of the datamart and then use Power BI's API to refresh the reports at different schedules. You can create different flows in Power Automate to refresh the datamart at different schedules, and then use the Power BI API to refresh the reports based on the schedule.
Another potential solution could be to use Power BI Paginated Reports, which allow you to create reports that can be scheduled to run and delivered to a variety of destinations, such as email or a file share. You could create a paginated report that connects to the datamart and contains all the necessary measures, and then schedule that report to run at the desired intervals.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for the response and suggestions.
Could you please elaborate on how exactly I can "use Power BI's API to refresh the reports at different schedules"? What type of connection should I select?
To make it more clear what I am trying to achieve. The datamart can be set to the most frequent refresh schedule (e.g. hourly). Monthly, daily, and on-demand refreshes can be triggered even manually. The main goal is that they will refresh independently from each other. At the moment all 5 reports are connected to the datamart via DirectQuery, so setting different schedules on the datasets level does not work, all five reports display data that is in the datamart.
I will explore Paginated Reports, but it would be better to find a solution that would work with regular reports, as I already have several that I want to reconnect to the datamart.