Microsoft Power BI is a powerful tool for creating reports & visualizations.

This guide describes the steps needed to get OpenTrack data streaming into Power BI from your account.

Note that this integration is somewhat complex and technical. We'll do our best to make it simpler in future versions 😅

Here's what you'll need:

First you'll want to configure a dataset in Power BI to house your OpenTrack data.

Create a new Streaming dataset:

Select "API":

Give your dataset a name, e.g. “OpenTrack Receiving Dataset”, enable “Historic data analysis”, and add some columns that you're interested in storing:

Now click "Create".

Log into Power Automate and create a new "Instant Cloud Flow"

Enter a name for the flow, scroll down and choose the “When an HTTP request is received” trigger (Premium). Now click “Create”:

Set up the trigger in order for it to understand the incoming payload. Expand the “When a HTTP request is received“ pane and click on “Use sample payload to generate schema”, paste an OpenTrack API payload example and click “Done”:

Now, add an action step which would push data from the payload to a Power BI dataset. Click on “+ New step”, type “add rows to dataset” in the search field and choose “Add rows to a dataset” Power BI action:

Choose your Power BI workspace, Dataset and the table “RealTimeData”. A list of table columns will appear:

Click inside the first column text field, a suggestion will appear on the right side . If it doesn’t appear, click “Add dynamic content”. In the Dynamic content window choose the name of the property from the incoming payload that you would like to map to the destination schema in Power BI:

Map the rest of the dataset columns to OpenTrack request payload properties and click “Save”:

Now, expand the “When a HTTP request is received” trigger and copy the URL. This is the url that you will configure as a webhook in your OpenTrack account.

If you have Postman, or any other HTTP Client, you can test out the Flow by making a request with the OpenTrack payload to the url you copied:

Now you can take the url you copied from Power Automate, and use it to register a webhook in your OpenTrack account.

That's it! Now when important changes occur in your data, OpenTrack will post a webhook and Power Automate will forward it onto Power BI in the correct format.

Have fun!