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 all,
Using PBI Version: 2.82.5858.961 64-bit (June 2020)
I'm trying to setup Incremental Refresh as per this article:
https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh
I created the parameters: RangeStart, RangeEnd
However, when I try to set up the Custom Filter on the Date Column, I can only use dates, I cannot use the parameters as options for the filter values.
Any ideas?
thx
w
Solved! Go to Solution.
Hi , @UncleLewis
When configuring incremental refresh in directquery mode, you first need to create two "Date/Time" type parameters named "RangeStart", "RangeEnd".
From the screenshot you shared,it seem that you create custom filter in model view rather that in the view of "Transform Data" .
In addition,make sure the type of the column need to apply custom filter is "Date/time" rather than "Date".
If not ,please convert it.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @UncleLewis
When configuring incremental refresh in directquery mode, you first need to create two "Date/Time" type parameters named "RangeStart", "RangeEnd".
From the screenshot you shared,it seem that you create custom filter in model view rather that in the view of "Transform Data" .
In addition,make sure the type of the column need to apply custom filter is "Date/time" rather than "Date".
If not ,please convert it.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Both RangeStart and RangeEnd parameters need to be declared as DateTime in the parameter settings. They must also both appear as part of conditions in the transforms of the data source that you want to switch to incremental.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |