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.

     

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
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.