Incremantal refresh cannot setup

[anusha_2023]

I have setop the Reange Parameters as below

The table that I want to setup is supporting Query folding as well which I can confirm this way:

In the Custom Fileters on date/time field I could not see the parameter that I created which are RangeStart and RangeEnd to setup the on the filed. I cross checked and conform that the type of Voucherdate, RangeStart, RangeEnd are date/time fields

Is there anything I am missing in the process to settings. Please guide me

[az38 · Accepted solution]

Hi @anusha_2023 

It looks like you are triyng to filter out rows in a Table view in Report desing mode.

Configure these filter in Power Query Designer (a window in which you configured data sources and parameters)

[uzuntasgokberk · Accepted solution]

Hello @anusha_2023 ,

For ınceremental refresh you need to follow the query folding issue. İt seems you accomblished it. The next step is create RangeStart and RangeEnd from manage parameters in Power Query.

After that you need to filter your date/time column.

Lastly, create incremental refresh policy.

More information about incrementel refresh one by one you can follow the link:
target=_blankhttps://medium.com/microsoft-power-bi/power-bi-hidden-treasure-incremental-refresh-7e91...

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

[az38 · Accepted solution]

Hi @anusha_2023 

It looks like you are triyng to filter out rows in a Table view in Report desing mode.

Configure these filter in Power Query Designer (a window in which you configured data sources and parameters)