Load Azure Devops Data into Power BI using Odata

In this blog we will see how to fetch Azure Devops Data and based on it create Visualization as per requirements.

Step 1: Go to Azure Devops > Go to User Setting > Personal Access Token 

Step 2: Once Clicked on Personal Access Token, click on New Token, following popup will appear. 

Enter details Name, organization and Expiration and specify Scope. 

New popup will appear, and it will generate access token key, copy it. 

Step 3: Prepare the OData URL 
            Sample OData URL: https://analytics.dev.azure.com/{OrganizationName}/_odata/{version}/ 

 In our Case, Organization is gvishwakarma Version is  v1.0 

Then URL will be https://analytics.dev.azure.com/gvishwakarma/_odata/v1.0/ 

Step 4 :Open Power BI click Get Data > select OData Feed 

Sample Data 

Once data loaded in power BI we create visualization as per requirement. 

Hope this Helps! 

Share Story :