How can I connect PowerBi to Queries in Azure Devops?

user_7933031 0
Viewed 2605

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.

powerbi-desktop powerbi azure-devops
1 Answers

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:

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/overview?view=azure-devops#supported-data-connection-methods

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.

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/analytics-views-create?view=azure-devops

Or you can use OData queries to filter field criteria directly.

user_54258250
Related