cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wendywang Regular Visitor
Regular Visitor

how to connect on premise Team foundation server

I try connect our internal TFS,  We are not Visul studio online version, Is any one know how to connect ?

I tried, but just can see a few related data, if anyone connect already, please help me ,thank you very much. 

1 ACCEPTED SOLUTION

Accepted Solutions
cosborn1231 Regular Visitor
Regular Visitor

Re: how to connect on premise Team foundation server

Hey WendyWang,

 

To report in Power BI off of a on prem TFS, I downloaded the TFS Add in for Excel, here

Once you have downloaded it in Excel go to File>Options>Add-Ins> Com-Add-In's and enable the Team Foundation Add in.

 

At this point a TEAM Tab will appear within your Excel Ribbon.

Using the Team add-in you will need to click "New List" (on the left of the ribbon), add the Server your TFS instance is on and select the Team Project Collection you are looking for.

 

Once you connect it will allow you import data based off of a TFS Query that is either specific to you (My Queries or Shared Queries). (these queries should be done beforehand to filter and pull the data you are looking to report on).

 

Once you import the data into a table, you have the ability to pull that excel file into Power BI to report on that TFS Data.

 

Downside: You will have to manually refresh the TFS query in Excel to keep data up to date, or have a script that does that for you.

 

View solution in original post

2 REPLIES 2
cosborn1231 Regular Visitor
Regular Visitor

Re: how to connect on premise Team foundation server

Hey WendyWang,

 

To report in Power BI off of a on prem TFS, I downloaded the TFS Add in for Excel, here

Once you have downloaded it in Excel go to File>Options>Add-Ins> Com-Add-In's and enable the Team Foundation Add in.

 

At this point a TEAM Tab will appear within your Excel Ribbon.

Using the Team add-in you will need to click "New List" (on the left of the ribbon), add the Server your TFS instance is on and select the Team Project Collection you are looking for.

 

Once you connect it will allow you import data based off of a TFS Query that is either specific to you (My Queries or Shared Queries). (these queries should be done beforehand to filter and pull the data you are looking to report on).

 

Once you import the data into a table, you have the ability to pull that excel file into Power BI to report on that TFS Data.

 

Downside: You will have to manually refresh the TFS query in Excel to keep data up to date, or have a script that does that for you.

 

View solution in original post

Highlighted
MohanV Established Member
Established Member

Re: how to connect on premise Team foundation server

@cosborn1231 Is it possible to get the whole organization projects tfs data into excel by using the same...????

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 80 members 1,254 guests
Please welcome our newest community members: