Forum Discussion

Kish1999's avatar
Kish1999
Icon for Helper II rankHelper II
2 years ago
Solved

Incremental refresh for Jira Data

Hello All, We use connectors to bring in the data from Jira in Power BI using Odata. The issue with this is that we are not able to use incremental refresh in our dataset and so the refresh takes wa...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

next step is to create two datetime parameters RangeStart and RangeEnd, and to use them as filters in your query. Ideally directly in the ODATA query as otherwise you won't have any performance gains.

Kish1999's avatar
Kish1999
Icon for Helper II rankHelper II
2 years ago

Hello Ibendlin, Can you please specify what do you mean by "Directly in ODATA query"?

    • Kish1999's avatar
      Kish1999
      Icon for Helper II rankHelper II
      2 years ago

      Thank You Ibendlin, I am able to apply $filter to the Odata query and able to filter on a date. Can you please elaborate how i can use the RangeStart/End parameter in $filter.

       

      Thank You for your help.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Do two date filters.  ge RangeStart and lt RangeEnd.