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() -1. So that my parameter is always takes 1 days ago date from current date.

 

If someone knows about this please help!!

 

Thanks & Regards

Vaishali 

 

 

Need Help

3 Replies

  • 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