cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dtran
Helper II
Helper II

Incremental refresh can not toggle to ON

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.

RangeStartRangeStartRangeEndRangeEnd

 

 

Here is my Filter Rows screenshot:

Filter RowsFilter Rows

 

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

Incremental refresh can not toggle to ONIncremental refresh can not toggle to ON

Please advise! 

Thank you in advance!

 

Dennis

 

 

2 ACCEPTED SOLUTIONS

@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
🙂

View solution in original post

v-kelly-msft
Community Support
Community Support

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!

View solution in original post

6 REPLIES 6
v-kelly-msft
Community Support
Community Support

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!

View solution in original post

amitchandak
Super User
Super User

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

@amitchandak 

 

-What do you mean "loaded data once"? 

-The date column is date_key in my_table.

 

 

@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
🙂

View solution in original post

nandukrishnavs
Community Champion
Community Champion

@dtran 

 

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

 

filter-rows

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

@nandukrishnavs 

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

filter rowsfilter rows

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!