Incremental Refresh is not working

[Chalapathi]

Hi Team,

I am unable to configure the incremental refresh in the power bi.

I defined the RangeStart and RangeEnd and configured the filter in the specified column and close & apply.

In the power bi Desktop, gone to the Fileds section and selected (...) then tried to configure the incremental refresh, but Incrementally refresh this table, Slider is disabled. unable to selected the years and how many days the data to refresh.

Can you please guide no this. find the below screenshot.

Regards,

Chalapathi

[jayadev_kochi]

I had the same problem because parameter 1 & 2 I have given some other name instead of RangeStart and RangeEnd.  You need to use these values as Parameter1 & 2.

[Anonymous]

Hi @Chalapathi ,

Is the problem solved? If the answer is helpful to you, within can mark it as a solution, which will help other users to find posts on similar topics faster. If the problem is not solved, feel free to post more details about the problem.

Best regards,
Gao
Community Support Team

[Anonymous]

Hi @Chalapathi ,

1. What is your data source? Please check that the data source supports query folding and that your table contains a date column of date/time or integer data type.

2. Please check if the parameters are set correctly. The RangeStart and RangeEnd parameters must be date/time data types and are case-sensitive.

For example, here I change the parameter RangeStart to Rangestart.

The same thing happened. 

Hope this helps you.

Best regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data