Feature availability: The Analytics Marketplace extension
is available to all VSTS accounts and provides access to several useful
widgets, such as Cumulative Flow, Velocity, and Lead and Cycle Time. The Analytics OData endpoint, which provides a concise model over the VSTS suite for Work Item Tracking, Test, Version Control, and
Build, is in a closed preview and only available to select VSTS customers at this time.
Once you've created a Power BI Desktop file and the associated charts and tables, you can share those with others by creating a dashboard on PowerBI.com. This process walks you through how to do that.
Open the Power BI Desktop file with your data.
Click Publish on the Home tab.
You will be prompted to Sign in or create and if you don't have a Power BI account you can create one. Click Sign in
If you are already signed in, the dialog will go away and you will see a Publishing to Power BI message. After the publishing is complete you'll see a success message.
Click the Open 'file name' in Power BI link
Expand the navigation pane in Power BI and select the work space that you selected when you published the report.
Click Datasets in the upper right corner.
Click the ellipsis next to the dataset that represents the report you just loaded (this is typically the file name.
Click Schedule Refresh.
Click the Edit credentials link next to ODATA under Data source credentials as shown here:
Select the appropriate authentication option (as discussed in Client Authentication Options).
Use oAuth2 for Azure Active Directory (AAD) credentials.
Use Basic for PAT credentials
See Client Authentication Options for more information on acquiring credentials.
- Click Sign in.
At this point the data will update on your scheduled basis using the credentials entered.
If you are using a Personal Access Token, remember that the token expires on a set interval. When it expires you'll need to update the credentials. Otherwise the report, while still displaying data, won't update with the latest data.