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