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.
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
- Make sure you have enabled or installed Analytics.
Make sure you have configured the permissions required to access Analytics.
Open Power BI Desktop. If you need to install it, do that now.
Choose Get Data from either the welcome page or the Home ribbon.
Next, select Other>OData Feed and choose Connect.
In a supported browser, enter the URL in the following format:
If the OrganizationName is fabrikam and the version is v1.0, then the URL is
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.
You'll see a prompt to authenticate against the service. If you have not done so previously, see Client Authentication Options.
Next, select the entities you want to retrieve data for by checking those entities.
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
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.