Integrate commit and pull request details from ADO to Power BI

[XavierI]

I'm new to Power BI.

What is the best way to integrate the pull requests and commits made in ADO with power bi reports? I can view every table after connecting using oData. How can I obtain commit and pull requests? Is it feasible to obtain the information?

 

[rajendraongole1 · Accepted solution]

Hi @XavierI - you can use OData or the Azure DevOps REST API to access data related to pull requests and commits.

For commits, you will need to access the Git Repositories API to retrieve commit data.For pull requests, the Pull Requests API is used to get information about each pull request.

Git REST API for Azure DevOps Services - Azure DevOps Services REST API | Microsoft Learn

if necessary tables are not poping up , you can try web approach as well.

Open Power BI Desktop.>>Go to Get Data > Web.>>Use the REST API URL (mentioned above for commits and pull requests).>>After loading, transform the data in the Power Query Editor as needed.

Hope this helps.

[XavierI]

Thank you for your response and support 

I attempt to get the commit request; I have included a picture below, I received the response, however the same api link is not working in power bi.

Attached image of PBI, I appreciate your assistance in advance.

[XavierI]

I missed the authentication part, Now it is working fine.

Thanks for your support !!