How to schedule refresh only certain Custom Partitions and not others?

[iBusinessBI]

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

[TomMartens]

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

[iBusinessBI]

@TomMartens 

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)?

[TomMartens]

Hey @iBusinessBI ,

unfortunately, there is no setting of a partition that will be recognized by the Service.

Regards,

Tom

[iBusinessBI]

@TomMartens 

Then how does Incremental Refresh recognizes that "old" partitions should not be refreshed?

It has to know somehow to only refresh last partitions....

I want to implement the similar logic...

[TomMartens]

Hey @iBusinessBI ,

the "incremental" refresh is using datetime fields, how to configure incremental refresh is described here:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs

Regards,

Tom

[iBusinessBI]

I have read the article and played with this for many hours.

It doesn't deal with my scenario where I have 2 different datasources.

So I am trying to do something similar to incremental refresh, but with custom partitions.

An incremental refresh policy somehow "tells" the shceduled refresh to only refresh certain partitions and not others.

I wish to re-create a similar policy with custom partitions