How to make dynamic parameters for incremental load

[Vaishali04]

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 

[Mariusz · Accepted solution]

Hi @Vaishali04 

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

[Vaishali04]

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]

Hi @Vaishali04 

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