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 :

Name and sharing options

The General tab of configuration where you can set the name, description and sharing of the view.

Filtering optionsWork item tab showing a view filtered to Priority 1 bugs on the Fiber Suite App team and the Fiber Suite report team.

 Views columns

The fields tab shows a list of the view's common fields with the options to customize the list.

Time period and granularity

The history tab set to a rolling period of 30 days on a weekly granularity starting on Mondays

Test your view in get performance estimationsThe verification tab showing the result of a successful verification with 76650 estimated rows.

To Learn more about the different configuration options see Create an Analytics view .

How to use views in Power BI ?

Once views are created, you can open them in Power BI desktop. Use the VSTS Power BI Data Connector to select your view and start creating reports!

Power BI VSTS connector displaying the list of available views for this account.

Need help getting started? Try creating a daily bugs report based on a new analytics view.

Have questions or feedback?

Feel free to post questions or feedback below and be on the lookout for these changes coming to your VSTS account over the next couple of weeks!

Author: Romi Koifman

Program Manager for Visual Studio Team Services at Microsoft

2