Using Parameters in Native Query for Incremental Refreshes

[goutisd]

Hi, 

I'm hoping you experts can assist me. I'm trying to incorporate a couple parameters "Start Year" and "End Year" into my native query so I can take advantage of incremental refresh. I thought I had incorporated the parameters correctly (see code below), but when I try to set up the refresh policy in Desktop, I get a message saying I need to set up parameters. I attempted to filter the query using the parameters outside of the native query, but it looks like the whole thing unfolds as it takes forever to refresh. What am I missing here? I tried doing some research and couldn't find much. Thank you!!

[Anonymous · Accepted solution]

Hi @goutisd 

If you want to use the incremantal refresh, you need to make sure that

1.The paramater name shoule be 'RangeStart' and  'RangeEnd'.

2.The type of the patamater must be date/time.

3.Make sure the data source support query folding.

You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#requirements

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DallasBaba]

@goutisd 

Please refer to This video should be useful for you:  YouTube  Patrick's covers Native Query for Incremental Refreshes. 

Read More details:   Microsoft Learn

 If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

@goutisd