Connect Power BI with Azure DevOps on premise

Question

We have TFS 2019 installed on premise and 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". Can u advise how to connect Power BI to a TFS on premise, we didn't find helpful material searching for it on the internet.

Answer 1

1. Azure DevOps Server is running and you can log in into the web portal of the Server
2. Analytics View option is enabled and you should have access to view/edit them.
3. For the on-premise Azure DevOps Server, the Collection Url must be the team collection URL instead of simple ServerName
The team Project name is one of your project names.  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.

Want to become Azure Developer, check out this Azure Tutorial.

If you are keen to learn about the various Azure skills then this Azure Certification availed by Intellipaat is the right course for you. This course will help you learn to master Azure skills and ace the Azure certification exam!