Forum Discussion

sgallo's avatar
sgallo
Advocate V
8 months ago
Solved

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 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?

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • sergej_og's avatar
    sergej_og
    Super User
    8 months ago

    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

  • Abhilash_P's avatar
    Abhilash_P
    Super User
    8 months ago

    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