Get pull request data of Azure DevOps with Power BI

[Lopez0090]

I want to get data from Azure DevOps Pull Request with Power BI (To create a report).

However, in Power BI Desktop, only Boards are supported, and Repos Data cannot be acquired.

Please let me know if there is any way.

Thank you in advance.

[Taenada]

You can use the Azure DevOps REST API to get data from Power BI. You can check this post if it can help.
https://note.datengineer.dev/posts/how-to-create-azure-devops-pull-requests-reporting-with-power-bi/

[Anonymous]

HI @Lopez0090 

Repos Data pull is not yet possible as per my knowledge.

[amitchandak · Accepted solution]

@Lopez0090 The information you have provided is not making the problem clear to me. Can you please explain with an example.

Check if these can help

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devop...

https://community.powerbi.com/t5/Community-Blog/PowerBI-CICD-using-Azure-DevOps/ba-p/769244

https://community.powerbi.com/t5/Desktop/Power-BI-data-to-Azure-DevOps-VSTS-dashboard/td-p/1095378

https://blog.scottlogic.com/2020/04/09/how-to-connect-power-bi-with-azure-devops-and-jira.html
Appreciate your Kudos.

[Lopez0090]

Looking for Pull Request information from Azure Dev Ops.
Specifically, the number of times that each pull request was voted "Wait or author", or "Reject".
Any way to get this information?

I’ｍ thinking about how to execute DevOps API with Logicapps and Power Automate,

but I do not know how to do it.