Getting data from Azure DevOps

[Markzolotoy]

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

[v-jingzhang]

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.

[Markzolotoy]

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.