Forum Discussion

bongmw's avatar
bongmw
Helper I
5 years ago
Solved

Retrieving Incremental Refresh Configuration on Power BI Service

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!

 

 

3 Replies

  • 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.

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