Forum Discussion
Helper ICan 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 views and it works only for OData Queries? is it correct.
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:
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.
4 Replies
KevinChantSuper User
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
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-dineshyaCommunity Support
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