unable to setup incremental refresh -

[vdog01]

Hello

I'm having difficulties setting up an incremental refresh in Power BI.

I've set up the two parameters as described

Parameters

The column that I'm trying to use as a incremental is defined as date/time

Date Column

However, when I try to specify the parameter, it doesn't seem to let me use the parameters

i'm following the steps from this link

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

what am i doing wrong?

[edhans · Accepted solution]

You have to change the filter to not ask for dates, but for parameters.

Pretty sure you can also put in any date, then change the formula bar and remove the date and replace with your parameter.

Table.SelectRows(#"Added Workday", each [Date] = #date(2019,1,1)

would become

Table.SelectRows(#"Added Workday", each [Date] = test)

Where "test" is the test parameter I set up.

[vdog01]

That was it!

I changed it to parameter and it works!

Thanks!