Forum Discussion
sgallo
8 months agoAdvocate V
Incremental Refresh does not recognise parameters
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...
- 8 months ago
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
sergej_og
8 months agoSuper User
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