Forum Discussion
Azure devops connection in 2 steps
Hi BDijkslag
You may have a look at this blog: Querying the Azure DevOps Work Items API directly from Power BI
You can create a query to get data of a single work item first, then convert it into a custom function with the work item id as a parameter.
Work Items - Get Work Item - REST API (Azure DevOps Work Item Tracking)
Once you have a list of all work item ids in a table column, you can invoke above custom function to add a new column to the table. In that column, it will invoke the function on every row with the row work item id.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
Hi BDijkslag
You may have a look at this blog: Querying the Azure DevOps Work Items API directly from Power BI
You can create a query to get data of a single work item first, then convert it into a custom function with the work item id as a parameter.
Work Items - Get Work Item - REST API (Azure DevOps Work Item Tracking)
Once you have a list of all work item ids in a table column, you can invoke above custom function to add a new column to the table. In that column, it will invoke the function on every row with the row work item id.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!