Forum Discussion
How to schedule refresh only certain Custom Partitions and not others?
I am trying to do something similar to incremental refresh but not based on date/time, but on some other logic.
I've created custom partitions as explained here:
https://www.youtube.com/watch?v=6CRqdsLjHNA&t=127s
I have 6 partitions: A,B,C,D,E,F
How can I the tell the service to only refresh partitions A, B, and C, but not D, E, F
6 Replies
Hey iBusinessBI ,
refreshing custom partitions is more complex than a "simple" refresh.
This article describes how you can use TMSL to refresh a single partition: Refresh command (TMSL) | Microsoft Docs
But what you also need and this is even more complex is to create an application that scans the underlying source, detects change, and initiates a partition refresh. Of course, this application needs to manage the detection of the change to avoid unnecessary partition refresh. This can be solved using Power Automate and a SharePoint used to store detection of change and the latest partition refresh.
Implementing this kind of solution often spans multiple days, sometimes weeks, depending on the level of complexity and the "easiness" the underlying data source reveals change.
Hopefully, this gets you started.
Regards,
Tom
Thanks Tom.
I understand this is somewhat complex and not out-of-the-box.
In my scenario, I do not need to detect changes, only to always process the partitions A, B and C. But not process all the rest.
Before exploring the Power Automate or similar solutions, I thought I have some more straight-forward option.
Maybe, can I set some property of all the partitions to "Do not process", except for A, B, C?
In such way, the scheduled refresh will skip all the partitions except for A, B, C?
Is there such a property I can change (via Tabular Editor or some other tool)?
Hey iBusinessBI ,
unfortunately, there is no setting of a partition that will be recognized by the Service.
Regards,
Tom
