Changing partitions in incremental refresh

[rjose]

Hi all,

I have a dataset incrementally refreshing on cloud on a quarterly basis. Currently, the set up is 2022Q1, 2022Q2, 2022Q3 loaded and 2022Q4 is refreshing on a daily basis. I would like to make the partitions to a monthyl level - 2022Q101,2022Q102,....,2022Q410 loaded and 2022Q411 refreshing on a daily basis. Is it possible to change the partitions without having to reload the data? Anytime, I chnage the increment refresh policy the data disappears (this is solved when I reload the partitions).Any help on this is much appreciated.

[v-yueyunzh-msft · Accepted solution]

Hi , @rjose 

As far as I know, when you change the incremental refresh policy, you need to re-refresh the full amount before you can update to the new partition.

Because different query folding statements are generated according to different incremental refresh strategies, you need to refresh again to get the latest data.

For more information, you can refer to :
Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Micr...

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly