Is there a way to get more information from the Azure DevOps boards connector?

[data_newbie]

Hello!

My company uses Azure to manage our agile way of working. I'm trying to build a Power BI report that shows extensively how many tasks have been delivered in a specific sprint, how many hours were spent on each of them, priority levels, etc. I know this information exists somewhere because, on the Azure platform, we have these fields:

However, while using the Azure connector on Power BI, I only get these columns (ignore the PI (Azure), Sprint (Azure) and StartDate fields, these are calculated columns):

The connector I'm using is called "Azure DevOps (boards only)". Is this the correct one? Am I able to retrieve at least the data regarding the amount of hours worked on each task through some other mean?

Thank you!

[Anonymous]

Hi @data_newbie ,

An easy way is to call the flow to get work items and store them in she sharepoint list. Then you can create a power bi report to get items from sharepoint list.

Best Regards,

Wearsky

[tackytechtom]

Hi @data_newbie ,

There is another way to connect to Azure DevOps:

Connect using Power Query & Azure DevOps functions - Azure DevOps | Microsoft Learn

I tried this myself, when I wanted to connect to the repository of my DevOps project in order to create automated documentation.

I think, you still need to try a few things here, but it might still get you pretty far.

Hope this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/