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

问题描述

我们的公司正在从TFS本地过渡到Azure Devops Service，因此使用TFS_Warehouse的所有内部团队报告将不再起作用。我能够从分析视图中提取工作项信息，但不知道如何将诸如Iteration数据（以前是TFS_Warehouse中的DimIteration中的数据）提取到Power BI中。有人可以协助吗？我从头开始，对Azure Devops的了解很少，也没有在R脚本之外使用Power BI或从SQL Server导入查询的知识，所以任何人都可以通过Power BI& amp;提供有关如何执行此操作的尽可能多的信息。

谢谢！

解决方案

您可以参考

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

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屋！