Forum Discussion
unable to setup incremental refresh -
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?
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.
2 Replies
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.
That was it!
I changed it to parameter and it works!
Thanks!
