Can we setup Incremental Refresh on Analytics Views of ADO?

[sravs2007]

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 views and it works only for OData Queries? is it correct.

[Olufemi7 · Accepted solution]

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:

• Power BI Incremental Refresh

• Azure DevOps Analytics Views

[KevinChant · Accepted solution]

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 · Accepted solution]

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:

• Power BI Incremental Refresh

• Azure DevOps Analytics Views

[v-dineshya]

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]

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