Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to make dynamic parameters for incremental load

Hi,   I am facing two issues.   1. Not getting "Incremental refresh policies " option in settings of power bi desktop . I am using MAY 2020 version. 2. How to make parameters dynamic like today(...
Need Help
Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

Please see the documentation for Incremental refresh below.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

 

To set the end date at yesterday, you RangeEnd Query should be like below.

let
    Source = Date.AddDays( Date.From( DateTime.LocalNow () ), -1 )
in
    Source

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanku Mariusz 

     

    I need to implement incremental load and for that i need to define parameter and that parameter will used to fiter the table. So I want that parameter to be dynamic. So that my data is always is less than current date.

     

    Please advice

    • Mariusz's avatar
      Mariusz
      Community Champion
      6 years ago

      Hi Anonymous 

       

      The function provided should do just that if need guidance on how to apply it, please see the documentation in my previous message.

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      LinkedIn