Incremental Refresh

[ppatil]

Hi Community..!!

I am stuck in between while creating incremental refresh.

Please refer the below images for your reference.

Incremental refresh option is not getting enabled.

I have created parameters as well. U can see in the below pic 

Please give me solution for the above problem.

[HotChilli]

Just go through this document and make sure your process matches.:

https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview 

The primary reason that the slider is not enabled is this:

"If the Power Query expression for the table doesn't include a filter based on the RangeStart and RangeEnd parameters, the toggle is disabled"

The column in the dataset has to be datetime (or an integer but that's a little more complicated).

It worries me that the table in your picture is 'date' - it is normally a Fact table.

[SanketBhagwat]

Hi @.

Did you applied the parameters to your data or table?
If not, your incremental refresh won't work.
Refer this; https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

If this post helps, then mark it as 'Accept as Solution' so that it could help others.

[ppatil]

Hi @SanketBhagwat 

Yes I have applied my parameters to the Table column.

[HotChilli]

After creating parameters, you have to define a filter in Power Query which uses those parameters.

It's in the Configure Incremental Refresh documentation

[ppatil]

Hi @HotChilli 

Yes I have applied my parameters to the Table column.

[SanketBhagwat · Accepted solution]

Hi @ppatil .
Please specify the period(AM/PM) in your RangeStart and RangeEnd parameters.

Regards,
Sanket Bhagwat


If this helps you, then mark it as 'Accept as Solution' so that it could help others.

[ppatil]

Thanks a lot @SanketBhagwat