Using Power BI with TEAM

Register Power BI as a product in the Administration > API Keys section

This will create an API Key for you to use in power BI.

Open Power BI desktop and select "Get data from another source"

Select "Other" from the list on the left and "Web" from the list on the right

Click "Connect"

Select the "Advanced" option

Fill out the form with the following options

URL Parts

Part1: https://<team-url>/WebApi/Incident/

Part2: 28

Part 2 of the URL part is used defines how many days worth of data you would like returned from the API.

HTTP Request header parameters

Name: "ApiKey"

Value: <the api key created in TEAM>

Click Ok to import the data into Power BI.

If you wish to change the number of days worth of data that is imported you can click the cog next to the Source to open the JSON dialog and adjust the second URL part to be a different number.

The data comes from TEAM in the form of JSON data and Power BI will convert it into a list of incidents. Fields like IncidentActions and Milestones will appear as lists within this table.

For more information on how to split this information into another table that has relational links to the main Incident table please see this informative YouTube video.