Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |