cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eddie Frequent Visitor
Frequent Visitor

Visual Studio Team Services

I need to create a report for data from TFS using Visual Studio Team Services. Getting data from TFS is only available in Service and not the desktop version. I need to model the data and create relationships. Does anybody know how to do that in Power BI Service? Again Power BI desktop does not connect to TFS. I need a work around.

 

Thanks,

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Visual Studio Team Services

@Eddie

 

Currently, it's not possible to do modeling on Power BI Services. However, there's a workaround to connect TFS in Power BI Desktop. You can download the TFS add-in for Excel, connect TFS and import tables into Excel. See: Connect Microsoft Excel or Microsoft Project to a team project. Then you can use Excel as data source to import those tables into Power BI Desktop for modeling.

 

Regards,

Highlighted
Mike_Carlo
Advisor

Re: Visual Studio Team Services

I am having the same issue.  Here is an article I have found that states you can connect VSTS to Power BI desktop by using a oData connector from PowerBI Desktop.  

 

https://www.visualstudio.com/en-us/docs/report/analytics/access-analytics-power-bi

 

I tried to get the connection to work for acouple of days but I was unsuccessful.  It looks like you need to enable a preview feature called "Analytics".  This enables the odata feed to the VSTS oData.  See connection methods below:

 

https://www.visualstudio.com/en-us/docs/report/analytics/client-authentication-options

 

Maybe these articles will help you out.  If you get the service connected please let me know as I am having the same issue.

 

 

 

Mike Carlo ( https://powerbi.tips )
mike@PowerBI.Tips

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 286 members 2,792 guests
Please welcome our newest community members: