cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rdias
Helper I
Helper I

Power BI with Devops: how to retrieve all work items in a Release

Hi

I have created some Power BI dashboards for the Scrum team with Azure DevOps data, for a project. We need to add a page with the list of work items contained in each Release, however I am not being able to get this 😞 I have spent some hours looking around the documentation but have not found it out. 

I appreciate if anyone out there can help!

 

Thanks,

Rosie

1 ACCEPTED SOLUTION

Hello

after making sure the configurations in teh attached article were in fact correct in our DevOps configuration (they were not 😞 we missed a checkbox!) :How to retrieve all work items associated with a release pipeline using Azure DevOps API | Developer...

 

We can now query as described in this document. However only for the future sprints (for which this configuration is valid), for the previous sprints we need an alternative solution, below.

After session with Microsoft Engineer we also may be able to go by Builds (query work items in a build associated with the Release) However this is a more complex thing to build automatically.

Hope this helps someone out there!

 

All the est,

Rosie

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @rdias 

 

Sorry I don't have much experience in Azure DevOps. Based on my research, it seems there is no direct Analytics data showing work items contained in each Release at Azure DevOps side (or I have missed it). So my idea is to generate this info at Azure DevOps side first, then use OData queries or other connectors in Power BI to connect to it. Not sure if this is doable.

 

See if these links are helpful:

How to retrieve all work items associated with a release pipeline using Azure DevOps API | Developer...

How to view Work Items associated with a Release in Azure DevOps - Stack Overflow

Azure devops pipeline get work items between builds - Stack Overflow

How to query work items by build or release in Azure DevOps Boards? - Stack Overflow

 

Regards,
Community Support Team _ Jing

Hello

after making sure the configurations in teh attached article were in fact correct in our DevOps configuration (they were not 😞 we missed a checkbox!) :How to retrieve all work items associated with a release pipeline using Azure DevOps API | Developer...

 

We can now query as described in this document. However only for the future sprints (for which this configuration is valid), for the previous sprints we need an alternative solution, below.

After session with Microsoft Engineer we also may be able to go by Builds (query work items in a build associated with the Release) However this is a more complex thing to build automatically.

Hope this helps someone out there!

 

All the est,

Rosie

View solution in original post

Hi Thanks, I had already seen those posts before asking my question. We have enabled on DevOps side but I still can't list the releases, however in Microsoft documenation a screen shot shows this #7 (here:Access Analytics data from Power BI Desktop - Azure DevOps | Microsoft Docs) but I can't get it to list :on my screen when I connect. 

Also I need to call this within Power BI and the above don't seem to work for this integration :(.

 

Regards,

Rosie

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors