Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
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
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
@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
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 🙂
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 🙂
Apologoes...this is the correct screenshot. I'm using RangeEnd in the bottom parameters
filter rows
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
73 | |
54 | |
43 | |
37 |
User | Count |
---|---|
98 | |
64 | |
54 | |
48 | |
45 |