如何从 Azure Devops Services 获取 DimIteration 表信息到 Power BI? [英] How do you get DimIteration table information from Azure Devops Services into Power BI?

问题描述

我们公司正在从本地 TFS 过渡到 Azure Devops 服务，因此我们所有使用 TFS_Warehouse 的内部团队报告将不再有效.我能够从分析视图中提取工作项信息，但不知道如何将迭代数据(以前在 TFS_Warehouse 中的 DimIteration 中)之类的数据提取到 Power BI 中.有人可以帮忙吗?我从头开始，对 Azure Devops 或在 R 脚本之外使用 Power BI 或从 SQL Server 导入查询知之甚少，因此任何人都可以提供有关如何通过 Power BI 执行此操作的尽可能多的信息.Azure Devops 将不胜感激.

谢谢！

解决方案

可以参考

希望以上内容对您有所帮助！

Our company is transitioning from TFS on-premises to Azure Devops Service so all of our internal team reporting that uses the TFS_Warehouse will no longer work. I am able to pull work item information from analytics views, but do not know how to pull data such as Iteration data (formerly in DimIteration in TFS_Warehouse) into Power BI. Can anyone assist? I'm starting from scratch here with very little knowledge about Azure Devops or using Power BI outside of R scripting or Import queries from SQL Server, so as much information as anyone could provide on how to do this through Power BI & Azure Devops would be most appreciated.

Thanks!

解决方案

You can refer to this documents to check about project and team iterations/areas information in azure devops.

You can get the iterations information by calling Restful Api

 curl -u {username}[:{personalaccesstoken}]https://dev.azure.com/{organization}/{project}/{team}/_apis/work/teamsettings/iterations?api-version=5.1

You can refer here to get started with Azure DevOps Services REST API.

Check the instructions here to get your PAT(personal access token)

To import the iteration data into powerBI, You can try below steps.

Choose Get Data From Web, and enter the url and authentication header.

Hope you will find above helpful!

这篇关于如何从 Azure Devops Services 获取 DimIteration 表信息到 Power BI?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！