Forum Discussion
Solved
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 The column that I'm trying to use as a incremental is def...
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.
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!