Skip to main content
Microsoft Idea

Power BI

New

Datamart: support multiple refresh policy/schedule for tables in a datamart

Vote (8) Share
Sam Nseir's profile image

Sam Nseir on 31 Aug 2022 07:36:08

Could we define a several refresh schedule policies/profiles and then apply to these to the tables in a datamart.

This would allow some tables to refresh more frequently, and other less, and others even no refresh.

Comments (2)
Sam Nseir's profile image Profile Picture

Jon Homiak on 29 Mar 2023 17:56:31

RE: Datamart: support multiple refresh policy/schedule for tables in a datamart

We absolutely need this. Having all tables refresh at the same time causes a massive hit to our source databases. I also want to control this using an API so I can track which tables failed refresh. This would also make it so the whole pipeline doesn't fail if only 1 table fails.

Sam Nseir's profile image Profile Picture

Richard Baldwin on 21 Dec 2022 19:49:35

RE: Datamart: support multiple refresh policy/schedule for tables in a datamart

To add to this an API for each refresh schedule/policy so they can be manually called.