Forum Discussion

UncleLewis's avatar
UncleLewis
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Incremental Refresh

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-incremen...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

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.