Forum Discussion
Using Parameters in Native Query for Incremental Refreshes
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!!
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.
2 Replies
- DallasBaba
Skilled Sharer
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.
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.
