Forum Discussion

sravs2007's avatar
sravs2007
Icon for Helper I rankHelper I
8 months ago
Solved

Can we setup Incremental Refresh on Analytics Views of ADO?

If Pull Data from Analytics View (WorkItems) from ADO into PowerBI, can we setup Incremental Refresh on this Views, Searched in ChatGPI, Setting up Incremetnal Refresh is not possible on Analytics vi...
General Comment
Show and Tell
  • Olufemi7's avatar
    Olufemi7
    8 months ago

    Hello sravs2007,

     

    Yes, that’s correct. Incremental Refresh is not supported on Azure DevOps Analytics Views because they don’t support query folding needed for partitioning.

     

    Incremental Refresh works only on tables or OData queries where Power BI can filter by a date/time column.

     

    References:

  • KevinChant's avatar
    KevinChant
    8 months ago

    Why do you need to configure incremental refresh for it?
    One alternative is to configure an alternative Analaytics view in ADO which only shows recent updates and load from there.

Olufemi7's avatar
Olufemi7
Icon for Super User rankSuper User
8 months ago

Hello sravs2007,

 

Yes, that’s correct. Incremental Refresh is not supported on Azure DevOps Analytics Views because they don’t support query folding needed for partitioning.

 

Incremental Refresh works only on tables or OData queries where Power BI can filter by a date/time column.

 

References:

  • v-dineshya's avatar
    v-dineshya
    Icon for Community Support rankCommunity Support
    8 months ago

    Hi sravs2007 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Hi Olufemi7 , Thank you for your prompt response.

     

    Hi sravs2007 ,  could you please try the proposed solution shared by  Olufemi7 ? Let us know if you’re still facing the same issue we’ll be happy to assist you further.

     

    Regards,

    Dinesh

    • v-dineshya's avatar
      v-dineshya
      Icon for Community Support rankCommunity Support
      8 months ago

      HI sravs2007 ,

      We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

       

      Regards,

      Dinesh