Capturing capacity planning in tfs 2017 to powerBI

Question

I am building TFS dashboard using PowerBI where I want to capture multiple things like sprint planning, velocity... etc. I was able to get all the data from warehouse database but only data which was I was not able to find is capacity planning.

Can anyone tell me from where we can fetch capacity planning..?

Thanks in advance.

Answer 1

It's not able to do this directly between TFS/Azure DevOps Server and PowerBI.

You could take a look at similar question below:

• Is it possible to connect Azure sprint capacity data into PowerBI?
• Retrieve user capacity for an iteration with ODATA

Instead, you may have to use Rest API Capacities - Get to get a team member's capacity.