Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Here is my Filter Rows screenshot:
When I get to the Incremental refresh screen, I can't toggle the button 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