Incremental refresh can not toggle to ON

[dtran]

Hi,

Need help to understand why I can't toggle Incremental refresh to ON.

-Power BI Desktop 2.79

-Power BI Pro

Followed the official documentation to set up the parameters for RangeStart and RangeEnd. 

Here my screenshots for them.

RangeStartRangeEnd

Here is my Filter Rows screenshot:

Filter Rows

When I get to the Incremental refresh screen, I can't toggle the button to ON.

Incremental refresh can not toggle to ON

Please advise! 

Thank you in advance!

Dennis

[nandukrishnavs · Accepted solution]

@dtran 

Parameter names should be "RangeStart" and "RangeEnd" and its type should be Date/Time, not just Date.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[v-kelly-msft · Accepted solution]

Hi @dtran ，

Yes, as suggested by @nandukrishnavs ,type for Parameter should be Date/Time, not just Date.Besides you should have a date/time column in your original table to be filtered by parameter.

Here is the reference.

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@dtran , have you loaded data once? There is a date column in the table ?

Refer:https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[dtran]

@amitchandak 

-What do you mean "loaded data once"? 

-The date column is date_key in my_table.

[nandukrishnavs · Accepted solution]

@dtran 

Parameter names should be "RangeStart" and "RangeEnd" and its type should be Date/Time, not just Date.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[nandukrishnavs]

@dtran 

You are using RangeStart instead of RangeEnd. Please verify that.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[dtran]

@nandukrishnavs 

Apologoes...this is the correct screenshot. I'm using RangeEnd in the bottom parameters

filter rows