Connect using the Power BI OData feed

Azure DevOps Services | Azure DevOps Server 2019

You can access Analytics data through the Power BI Desktop OData feed.

Important

This method works for small organizations, as it always pulls in all the data into Power BI. Most filtering specified in the Power Query Editor are done client-side. For information on other approaches, read the Power BI Integration Overview.

Access Analytics OData feed

  1. Make sure you have enabled or installed Analytics.
  1. Make sure you have configured the permissions required to access Analytics.

  2. Open Power BI Desktop. If you need to install it, do that now.

  3. Choose Get Data from either the welcome page or the Home ribbon.

    Power BI desktop splash screen, Get data button

  4. Next, select Other>OData Feed and choose Connect.

    Select OData Feed
  5. In a supported browser, enter the URL in the following format:

    https://analytics.dev.azure.com/{OrganizationName}/_odata/{version}/
    

    If the OrganizationName is fabrikam and the version is v1.0, then the URL is https://analytics.dev.azure.com/fabrikam/_odata/v1.0/.

    Select OData Feed

    Note

    Alternatively, you can enter the URL with the ProjectName specified which will trim the results by the specified project across all entities related to that project.

    https://analytics.dev.azure.com/{OrganizationName}/{ProjectName}/_odata/{version}/

  6. You'll see a prompt to authenticate against the service. If you have not done so previously, see Client Authentication Options.

  7. Next, select the entities you want to retrieve data for by checking those entities.

    Important

    Do not select any entity with the name Snapshot in it. These entities contain the state of every work item on every day since each work item was created. For repositories of any size this will lead to tens or hundreds of millions of work items which will not load. Snapshot tables are intended only for aggregation queries

    Select the entities of data to retrieve

    At this point, if you choose Load, Power BI Desktop will load all of the data in each entity. However, this may be more data than you want. To filter the data, select the entity to filter and choose Edit. This brings up the Query Editor. For each column on which you want to filter, select it and set your filter. When this is complete choose Close & Apply in the upper left corner.