We have TFS 2019 installed on premise, want to create PowerBI reports based on analytics Views that are already predefined in TFS. Selecting GetData in PowerBI yields a login screen with collection URL and Team Project. We entered TFS sever name in URL connection and the Team Project respectively, getting an error "invalid account". Prior to this PowerBI asked for Login, logged in with my microsoft user. Can u please advise how to connect Power BI to a TFS on premise, we didn't find helpful material searching for it on the internet. Thanks in advance.
3 Answers
Can u please advise how to connect Power BI to a TFS on premise, we didn't find helpful material searching for it on the internet.
Assuming you have Power BI Desktop in MachineA. Now you need to make sure:
1.The Azure Devops Server is running and you can login the web portal of Azure Devops Server(once called TFS) in MachineA's browser:
2.The Analytics View
option is enabled and you have access to view/edit them:
3.In Power BI Desktop: For on-premise Azure Devops Server, the Collection Url
shoule be the team collection url instead of simple ServerName or OrgName:
The Team Project name is one of your project name. For me I have Project ForTest
in organization Test
. And my full url of the project is: http://xxx/Test/ForTest/
. So I enter http://xxx/Test/
for Collection Url
and ForTest
(simple name of team project !!) for Team Project
, then it works well to connect to the server:
Ps: I use Azure Devops Server 2019 Update1(1.1) and latest Power BI Desktop downloaded from Microsoft Store.
Hope my steps make some help for you :)