You can connect your Visual Studio Online (VSO) environment with Power BI Online. At this moment it is not possible to connect to VSO with your Power BI Desktop client In order to connect your VSO environment to your Power BI environment you need to go to the website https://powerbi.microsoft.com/, and select Sign-in (I assume you have already created an account for Power BI).
Sign in with the account you would like to use for Power BI.
After login in Power Bi starts.
When you start it for the first time, it is possible that you have sample data loaded. My advice is to delete the sample Data set, Report and Dashboard in order to keep a clean working environment. Select for all three items (Dashboards, Reports and Datasets) the menu by selecting the ” . . . “, and choose “Delete” from the menu .
We now have a clean Power BI environment and we can connect to the VSO environment. Select Get Data and the bottom left:
A new window opens where you have the possibility to select different options (e.g. services, files and databases).
Select under “ Content Pack Library”, “Services” and select “ Get” (see screenshot below).
When you select get a new window opens and you get an overview of services you can use to connect to, Visual Studio Online is at the bottom of this screen:
Select Visual Studio Online, and select “Connect”
You must now enter the Account you would like to connect to. If you wan’t to connect to e.g. https://delta-n.visualstudio.com/ you only need to enter “delta-n”, not the entire URL (it allready assumes you will connect to visualstudio.com)..
I will connect to my own demo environment instead of delta-n.
It is possible that you have multiple projects in the selected account. You can choose to get all data from all projects, select the “*”, or you can enter the name of one specific project. Both options are valid, you need to decide how you would like to use the Reports and Dashboard. If you wan’t to use it for one project, just read data from that specific project. If you would to report over two or more projects, read all data and filter there where needed.
When the data is entered select Next
When the validation is successful you must Sign in, in order to finish the authentication (which works with oAuth2)
In the screen that opens you must accept the terms in order to Authorize Power BI to read the data from Visual Studio Online.
When you select Accept, the data will be imported.
When the import is finished, there will be a sample Dashboard and a sample Report available. You can use this to create your own, it gives an idea on how the reporting and dshboards work. But since it is a sample, you will need to change it to make it work for you.
In my next blog post I will work out some examples that will explain the possibilities you have when using Power BI.
If you have any questions or remarkt, please leave a comment below.