Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ppatil
Helper III
Helper III

Incremental Refresh

Hi Community..!!

I am stuck in between while creating incremental refresh.

Please refer the below images for your reference.

ppatil_0-1637323559078.png

Incremental refresh option is not getting enabled.

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

ppatil_1-1637323649548.png

Please give me solution for the above problem.

1 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.

View solution in original post

7 REPLIES 7
HotChilli
Super User
Super User

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
Solution Sage
Solution Sage

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.

Hi @SanketBhagwat 

Yes I have applied my parameters to the Table column.

ppatil_0-1637325646461.png

 

HotChilli
Super User
Super User

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

It's in the Configure Incremental Refresh documentation

Hi @HotChilli 

Yes I have applied my parameters to the Table column.

ppatil_1-1637325730772.png

 

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.

Thanks a lot @SanketBhagwat 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.