Refresh reports connected to one datamart with different schedules

[MariiaTeteriuk]

Hello everyone!

I need to connect several PowerBI reports to one datamart that should be refreshed with different schedules (monthly, daily, on demand). The datamart contains DAX measures that are used in all reports. What is the best way to accomplish this task?

Direct connection of reports to datamart does not solve the task as all connected reports refresh once the datamart is refreshed. Connection to datamart via SQL endpoint does not import measures. The only solution which I can think about is to create a separate datamart for each refresh schedule and connect them to the main one. In this scenario refresh of the main datamart does not affect reports connected to the related datamarts. However, in this scenario I will have to copy measures to each datamart, which is not very convenient in terms of measures maintenance. 

Are there any other ways to refresh reports connected to one datamart at different schedues?

[v-zhangti]

Hi, @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.

[MariiaTeteriuk]

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.