Want to get data from Azure DevOps repo's Pull Request data in Power B

[anshusoni]

I want to get data from Azure DevOps repo's Pull Request data in Power BI (To create a report).

Please let me know if there is any way.

[v-yilong-msft]

Hi @anshusoni ,

Based on your problems, here are my answers.

If you are in Power BI Desktop, select Get Data > Online Services > Azure DevOps (Boards only) for cloud services or Azure DevOps Server (Boards only) for on-premises.

You can read this document for a further study: Connect to Power BI Data Connector - Azure DevOps | Microsoft Learn

If you are in Power BI Service. you can read this document: Azure DevOps build pipeline integration with Power BI Desktop projects - Power BI | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[anshusoni]

Hi @v-yilong-msft thanks for the response,
The below link, you have shared is related to getting data from Azure DevOps Boards in Power BI dashboard-
 Connect to Power BI Data Connector - Azure DevOps | Microsoft Learn
And below link you have shared is related to integrate fiber workspace with git for version controlling and CI/CD pipeline.
Azure DevOps build pipeline integration with Power BI Desktop projects - Power BI | Microsoft Learn

My requirement is not getting data from Azure DevOps Boards or going for version controlling and CI/CD pipeline.
My ask is different. I want to get pull requests data from Azure DevOps Repos in Power BI to make reports in Power BI with pull requests data. Is there any way?