10.2 How to create your dashboards with PowerBI and display them within Iterpro

SETUP ITERPRO POWERBI CONNECTOR

 

 

• 0:00 select the PowerBi connector
• 0:56 activate the PowerBi connect
• 1:12 Add API credentials
  
  
  

GET DATA FROM ITERPRO API CONNECTOR

 

 

• 0:00 Get data from Iterpro
• 0:24 How to manage API calls and upload data to Power BI
• 1:44 How to visualize data and create dashboards

 

CREATE A DASHBOARD

 

 

• 0:00 introduction
• 0:15 dashboard creation example
• 1:06 adding filters

 

SHARE THE DASHBOARD IN POWERBI SERVICE

 

 

IMPORT THE REPORT IN ITERPRO

 

 

DOWNLOAD THE PDF REPORT

 

 

FEATURE DESCRIPTION

 

1. Configuring the Iterpro Connector

To start, you need to configure the Iterpro connector in Power BI:

• Open the file: After opening Power BI Desktop, locate the file IterproPowerBIconnector.mez received via email.

• Place the file: Move this file to the Custom Connectors folder located at Documents > Power BI Desktop.

  • If the folder doesn’t exist, create it manually and name it exactly Custom Connectors.

• Connector recognition: After pasting the file, wait a few seconds. Then, in Power BI, click Get Data > More, search for “Iterpro” and select the connector.

• Enter credentials: On the first connection, enter the credentials provided. Make sure the formatting is correct: username [space] : [space] API Key.

2. Importing Data via the Connector

Once configured, you can import data from Iterpro:

• Go to Home > Transform Data to open Power Query Editor.

• Click New Source > More and search again for “Iterpro”.

• After selecting the connector, you will see the list of available API calls.

• Select, for example, Teams List Events, check the box, and enter the parameters in the right panel.

• Click Apply to preview the data. If correct, press OK.

• You can transform the data by selecting only the desired events (e.g., a specific match) and filter further (e.g., session players column) to expand player-level details.

3. Creating the First Dashboard

Now that the data is imported, here’s an example:

• Use the table Teams List Events to create a visualization (e.g., Stacked Column Chart).

• Drag Player Name to the X-axis and Total Distance to the Y-axis.

• To split distances by first half, second half, and full game, add Split Name as a legend.

• To display only the full game, apply the filter Split Name = Game.

• Customize the chart using the visualization panel (colors, axes, titles, etc.).

 

4. Publishing the Report to Power BI Service

Once the dashboard is ready:

• Go to Home > Publish in Power BI Desktop.

• Select the target workspace and click Select.

• After uploading, check in Power BI Service that the report and dataset were published correctly.

 

5. Importing the Dashboard into Iterpro WebApp

To integrate the report into the Iterpro WebApp:

• Access Power BI Service, open the report, and go to File > Embed Report > Website or Portal.

• Copy the link from the first section.

• In the Iterpro WebApp, go to Custom Dashboard, click Add, enter a name, and paste the URL. Save to make the dashboard visible in your Iterpro account.