Forum Discussion

goutisd's avatar
goutisd
New Member
2 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
DallasBaba
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

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