Forum Discussion
Integrate commit and pull request details from ADO to Power BI
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.
Super UserHi 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.
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.
I missed the authentication part, Now it is working fine.
Thanks for your support !!