Azure devops Saydo in power Bi?

[bgashok]

I am looking for pulling sprint saydo from azure deveops to power bi? is it possible to have?

[SIndu29]

Did you find a solution for this? 

[bgashok]

Yes!

[SIndu29]

Can you please explain how you did that. If you can give a detailed explanation that would be great as I am new to Azure Devops and Power BI

[bgashok]

https://community.fabric.microsoft.com/t5/Desktop/Deviation-amp-comitted-calcuation/m-p/3745159#M121...

it's answered in above thread.

[mohitkumawat]

Hi,

to pull Sprint data from Azure DevOps into Power BI:

1. Get a Personal Access Token (PAT): Create a PAT in Azure DevOps with the necessary permissions.

2. Connect to Azure DevOps API: In Power BI, use the Web connector in Power Query to connect to the Azure DevOps REST API. You can use the following URL to access Sprint data:

3. Authentication: Provide your PAT for authentication.

4. Retrieve and Transform Data: Fetch Sprint data and shape it using Power Query in Power BI.

These steps will allow you to integrate and visualize Azure DevOps Sprint data in your Power BI reports and dashboards.
or you can check below link as well
https://learn.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devo...

[bgashok]

I am able to pull the data from Azure devops to power bi, but currently there is no SayDo data in Azure devops. I am trying to build it with calcuations, but having errors.

I have created a below table form Azure and would like to plot a graph with Sprint Sx in x-axis and calucated measue = (count of True in respective sprint /(Count of True in respective sprint + count of False in respective sprint)). How can I do it?

Id	Started sprint	Closed sprint	committed
1	S1	S1	TRUE
2	S1	S1	TRUE
3	S1	S2	FALSE
4	S1	S1	TRUE
5	S1	S1	TRUE
6	S1	S3	FALSE
7	S1	S1	TRUE
8	S1	S4	FALSE
9	S1	S1	TRUE
10	S1	S1	TRUE
11	S2	S2	TRUE
12	S2	S2	TRUE
13	S2	S3	FALSE
14	S2	S2	TRUE
15	S2	S2	TRUE
16	S2	S4	FALSE
17	S2	S2	TRUE
18	S2	S2	TRUE
19	S2	S5	FALSE
20	S2	S2	TRUE
21	S3	S3	TRUE
22	S3	S4	FALSE
23	S3	S3	TRUE
24	S3	S3	TRUE
25	S3	S5	FALSE
26	S3	S3	TRUE
27	S3	S6	FALSE