The goal of this project is synchronize a set of AzureDevOps workitems (User Stories, Task, Areas, Iterations, Features, Bugs) from multiple Azure DevOps projects in to TableStorage to enable centralized analysis of multiple projects using PowerBI dashboards.
There are a set of basic parameters that need to be supplied to the application for it to work. In the app.config you can set the following settings
| Property | Description |
|---|---|
| TfsUri | The azure devops url. |
| PersonalAccessToken | The azure devops personal access token with only basic permissions |
| AzureStorageConnectionString | The azure table connection string. |
| WorkItemSyncDate | Date from which you want to synchronize the “User Stories and Task” workitems. |
| Property | Description |
|---|---|
| ProjectName | The project name. You can get this information you project url. |
| AreaPath | The work itens area path. You can get this from the settings in you project |
| TeamName | The team name. You can get this from the security in you project |
This project currently allows you to synchronize Areas, Iterations, Tasks and User Stories. Check the class diagram for more details.
To start using the PowerBI dashboard follow these steps.
- Create an azure table in the Azure Portal.
- Configure the settings of the synchronization utility as described.
- Run the first data synchronization to fill all the tables with the necessary information.
- Open the PBI file and update the existing connection to match with yours.
- Update the dasboard.