Need help reading commit data from Azure Devops into PBI

[DmaumauBR]

Hi everybody, I would like to read commit data from Azure Devops into a PBI consult.

I have been able to load the data using this web consult suggested by AI

"https://dev.azure.com/ORG_NAME/PROJECT_NAME/_apis/git/repositories/REPOSITORY_NAME/commits?api-versi..."

But it only load the first 100 items.

I am a novice on PBI, so I do not know how to overcome this limitation.

Any help will be greatly appreciated.

[Anonymous]

Hi @DmaumauBR 

Based on your descriotion, you can consider to use Azure Devops connector instead of web connector.

you can refer to the following link about the connector.

Connect to Power BI Data Connector - Azure DevOps | Microsoft Learn

Or you can use odata connetor to connect, you can refer to the following。

Access Analytics data from Power BI Desktop - Azure DevOps | Microsoft Learn

Best Regards!

Yolo Zhu

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