Power BI and VSTS - Integration made easy

We are excited to announce an easy-to-use solution for integrating Power BI with VSTS Analytics. You don’t have to know how to write OData queries anymore! Our new feature Analytics views makes getting VSTS work tracking data into Power BI simple, and it works for the largest accounts. Similar to a work items query, an Analytics View specifies filters that scope the result of work items data and the columns. Additionally, views allow you to report on past revisions of work items and easily create trend reports.

We provide a set of Default Analytics views that work well for customers with smaller accounts and basic scenarios. Larger accounts might need to scope down the data they are pulling into Power BI. Analytics views let you do just that. Scope your data and history to exactly what you want to report on in Power BI. Analytics views you create in the Analytics hub in VSTS are immediately available to select from the VSTS Power BI Data Connector.

How do I create my own view?

Creating a view is easy. Name is the only thing mandatory. You can add as many filters as needed. A View can be scoped to one or more teams and Area paths. You can also have a view that includes data from multiple team projects. For example, the following images shows a view configuration for high priority bugs across two teams

When creating a new view in VSTS, you can control the following aspects :