Incremental Refresh does not recognise parameters

[sgallo]

Hey all,

I am trying to set up an incremental refresh on my main table: FactTransactionsIncremental. I have created and filtered the table in power Query between 2 parameters (called startdate and enddate).

It loads the data all fine and keeps the "View Native Query" clickable in the "Applied Steps" in Power Query too so it should be folded correctly.

The issue comes when I try to set up the incemental refresh I get the below picture with the error stating that i need to set up parameter - I have already set up parameters correctly as the table is being filtered by them

Any ideas?

[Abhilash_P]

Hi @sgallo ,

Please make sure to follow below steps

• Create parameters named RangeStart and RangeEnd (type: Date/Time).

• Filter your table using these two parameters.

• Apply the changes and set up Incremental Refresh again.

Also incrmental refesh will not for work non query foldable source
Can i know what is the data source here..?

Thanks

[sergej_og]

Hey @sgallo ,
as @GeraldGEmerick  mentioned correctly call the parameters in a right way + they need to be in a Datetime format.
After setting them up filter (in PQ) your corresponding datatime column in the fact table with those parameters. >= RangeStart and < RangeEnd or something like that. After your should be able to set up the incr. refresh in the loaded table.

Regards

[GeraldGEmerick · Accepted solution]

@sgallo Your parameters need to be called RangeStart and RangeEnd and those parameter names are case-sensitive. Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn