Forum Discussion
Azure devops Saydo in power Bi?
Hi,
to pull Sprint data from Azure DevOps into Power BI:
Get a Personal Access Token (PAT): Create a PAT in Azure DevOps with the necessary permissions.
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:
Authentication: Provide your PAT for authentication.
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-devops#connect-to-an-analytics-view
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 |