Forum Discussion
Azure devops Saydo in power Bi?
I am looking for pulling sprint saydo from azure deveops to power bi? is it possible to have?
6 Replies
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-viewI 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
Did you find a solution for this?
