Incremental Refresh

[Anonymous]

Hallo All

I have set parameters in my query. My RangeStart starts at 2016/12/01 which is where my dataset start and my RangeEnd is 2019/05/04 which is where dataset currently ends. Lastly I setup my incremental refresh to store rows from the last 3 years and update rows from the last 10 days. 

But still it refreshes the whole table when I refresh and in the sercvice it does not even recognise the parameters I set for the dataset. At this stage it does not seem to do anything.

Anybody knows why this is and what I can do to fix this?

[v-danhe-msft]

Hi @Anonymous ,

Could you have refered to below link about incremental refresh:

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#filter-large-datasets-in-power-bi-desktop

You could check the limitation in this documents.

Regards,

Daniel He