- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
RangeStart
RangeEnd
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
02-28-2025 06:59 AM | |||
02-11-2025 03:24 PM | |||
02-06-2025 04:29 AM | |||
11-13-2024 05:02 PM | |||
02-22-2025 09:40 PM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |