This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.
Solved! Go to 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:
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.
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.
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:
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
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
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.