Retrieving Incremental Refresh Configuration on Power BI Service

[bongmw]

Hi all,

Incremental Refresh is configured with Power BI Desktop (e.g. Store rows in the last x Years/Months, Refresh rows in the last x, Detect data changes etc.) before being published to Power BI Service.

Is there any way to retrieve these configuration values for a table after publishing to Power BI Service? Either with APIs, XMLA Endpoints or any other means?

I am aware of scripting a table with TMSL to retrieve the criteria that the table partitions are based on, but is there any way to retrieve the full configuration?

Thanks in advance!

[lbendlin]

It is worth mentioning that the implemented partitions may be quite different from what the developer is requesting, especially if the developer lives on a fiscal calendar.  Partitions are always bounded by regular calendar intervals at UTC.  Does't really matter much for the outcome, but worth knowing.

[bongmw]

Thanks @lbendlin ! I was looking under the "Partitions" bit of the definition and missed this completely!

[lbendlin · Accepted solution]

you mean like this?