Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Incremental Refresh - Power BI not detecting parameters

Hi,   We're looking to set up incremental refreshes for one of our queries, coming from an ODBC source. Following the suggestions in this link here, we defined two parameters 'RangeStart' and 'Rang...
Need Help
Tips and Tricks
NaveenGandhi's avatar
NaveenGandhi
Icon for Memorable Member rankMemorable Member
3 years ago

Hello Anonymous 

Once the parameters are set up, a Custom filter must be created in ur table that uses the above-created parameters. Did you do that?

 

Let me know if this helps!

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Naveen,

 

Thanks for the quick response. Yes, this step was completed with no problem. The issue we're having is that once we've loaded the data from Power Query the next step in setting up the incremental refresh, and this will not work.

 

Thanks,

 

Shane

  • NaveenGandhi's avatar
    NaveenGandhi
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Anonymous 

    I can suggest you couple of ways to debug this.

    • Please ensure you already enabled the "Incremental Refresh Policies" preview feature in desktop. 
    • See if you set RangeStart and RangeEnd as datetime, it should be defined as datetime
    • Can you check the last step of your query to see if native query is greyed out as below.

     

     

    • If this is greyed out, navigate to prior steps one by one and see which step still has native query not greyed out. Remove all the steps below that and try now.

     

    Note: don't remove the filter parameter step, just rearrange it.

     

    Let me know if this works!

     

    Regards,

    Naveen