Connect Power BI to your on Premise TFS

03-11-16-3-13-48-PM Power BI is a powerful tool which allows you to easily build interactive data visualizations from almost any type of data you have. This Microsoft tool can be used as a desktop app, mobile app or directly online. It is free of use if you don’t have a lot of data and quite cheap if you need more. I am not a business intelligence developer and I don’t have a BI background at all still I found Power BI a great way to quickly build my dashboards.

As an agile developer and scrum master I wanted to capitalize on the data we have from TFS and make even more complete dashboard than the ones built in. I tried online with my msdn linked Team Services account and It was so mind blowing that I immediately wanted to use it at work. BUT – there is a but – Power BI does not have a TFS connector for on premises TFS servers. And it’s clearly not in the top of their backlog.

So here is the trick to connect Power BI to your on Premise TFS platform.

  1. Download and install Power BI Desktop
  2. Launch Power BI and in the first screen click on Get Data03-11-16-2-56-10-PM
  3. On the Get Data window choose Database then SQL Analysis Services Database. Then click on Connect.
    If you don’t have rights to query this DB ask for a read access.
  4. Now enter the Server instance name and click on OK.
  5. In the Navigator window you can now choose which dimension you want to work on.
    For building dashboards regarding teams I use the Work Item perspective.03-11-16-3-05-26-PM
  6. Now you’re all set to build nice data visualization reports.

Another post will follow on how quickly build some reports with Power BI.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s