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.

Anonymous's avatar
Anonymous
Not applicable
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.