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!