Using PowerBI’s inbuilt Azure DevOps connector to get data

PowerBI is a great analytics tool and we have already discussed about how to get Azure DevOps data by different methods in PowerBI, here in this post, let us see about how to get data using PowerBI’s inbuilt connector Azure DevOps

Before using this option, we need to create analytics view in Azure DevOps to get the data.If you have not installed PowerBI, install it and then open it before following the below steps

Step 1: Open PowerBI

Step 2: Click on Get Data —>All –> Azure DevOps

Step 3: Enter the Organization name and Team Project name as shown

Step 4: You will get the list of views as shown and select your view on the left pane, then click on Transform Data ( Transform data allows you see the data before loading it)


Step 5: You will get to see all the data as seen below, here you can merge or append queries by loading other analytic views too and also you can do a group to get the data

Step 6: Once you click on “Close & Apply”, you will get the data loaded as shown

You may also like...

13 Responses

  1. December 7, 2020

    … [Trackback]

    […] Find More Information here on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  2. December 8, 2020

    … [Trackback]

    […] Read More Information here on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  3. December 9, 2020

    … [Trackback]

    […] Information to that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  4. December 15, 2020

    … [Trackback]

    […] Here you can find 49336 additional Information on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  5. December 18, 2020

    … [Trackback]

    […] There you can find 81563 more Information to that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  6. December 28, 2020

    … [Trackback]

    […] Info on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  7. December 30, 2020

    … [Trackback]

    […] Find More on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  8. December 30, 2020

    … [Trackback]

    […] Find More to that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  9. January 6, 2021

    … [Trackback]

    […] Read More here on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  10. January 16, 2021

    … [Trackback]

    […] Find More on on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  11. January 18, 2021

    … [Trackback]

    […] Info on that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  12. January 20, 2021

    … [Trackback]

    […] There you will find 68484 more Information to that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]

  13. January 21, 2021

    … [Trackback]

    […] Info to that Topic: azuredevopsguide.com/using-powerbis-inbuilt-azure-devops-connector-to-get-data/ […]