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 moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
I want to pull data from ADO Sprints. Specifically I want to build a chart that would show a progress on the stories/tasks. I am able to connect to Azure DevOps (Boards only). That gives the following structure:
Where I dont see any hours. Can that kind of data be retrieved?
Thanks
Hi @Markzolotoy
Do you connect to an Analytics view in Azure DevOps? Does this view include the hours field? You may need to edit the view or create a custom Analytics view that includes the field you want.
Create an Analytics view - Azure DevOps | Microsoft Docs
Or use OData queries to query the data you want.
Connect with data by using OData queries - Azure DevOps | Microsoft Docs
Reference:
Tasks & concepts using Data & Analytics - Azure DevOps | Microsoft Docs
Use OData queries to generate Power BI reports - Azure DevOps | Microsoft Docs
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
when I go on DevOps and modify existing View by adding a new field I dont see any "hours" in the dropdown with available fields.
Check out the April 2026 Power BI update to learn about new features.
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.
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 30 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 53 | |
| 31 | |
| 23 | |
| 23 |