Forum Discussion
Helper IIIncremental 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.
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
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 🙂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,
KellyDid I answer your question? Mark my post as a solution!
6 Replies
- nandukrishnavs
Community Champion
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 🙂
dtranApologoes...this is the correct screenshot. I'm using RangeEnd in the bottom parameters
filter rows
- amitchandak
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
- dtran
- nandukrishnavs
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-msftCommunity 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,
KellyDid I answer your question? Mark my post as a solution!
