'How can I connect PowerBi to Queries in Azure Devops?
I need to get he data from the queries of the Azure devops. Im trying to establish a direct connection between them. Im able to access all the other items like Boards,tasks, work items etc. But, im unable to see the Query. How can I rectify this issue?
Thanks in advance.
Solution 1:[1]
Generally, you can pull data from Analytics into Power BI in one of three ways:
- Connect using the OData queries
- Connect using the Azure DevOps Data Connector
- Connect using the Power BI's OData Feed connector
More details, please check the following link:
It seems you are using the second way. This connector only works with Boards data (work items) and does not support other data types. You can not establish a direct connection between Query and PowerBI. But, as the Query is used to list work items based on field criteria you specify, you can create a custom Analytics view in Azure DevOps and add filters by field criteria, then you can connect to this custom Analytics view in PowerBI.
Or you can use OData queries to filter field criteria directly.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Cece Dong - MSFT |