Connecting Analytics to PowerBI

Orkestra's web API allows you to connect your analytics directly with PowerBI. Here are the steps (You nee Orkestra 1.2.0 or more recent for this)

In Orkestra

1. Getting your PowerBI Url from the Account section of Orkestra

Clicking on the Power BI button will copy the Url to your clipboard

You can also filter the querry by date using the following URL format

https://api.orkestra.online/prod/Analytics/OrkstraUsageAnalytics?userId={userId}&startDate={startDate}&endDate={enddate}

If you don't specify an endDate, it will use the current date. And if you don't specify a startDate, it will use the date of the first recorded run.

In PowerBI

1. Go to the opening screen of PowerBI and select “Get data from another source”

2. Select “Other”, then “Web”, then “Connect”

3. Paste the Url from your clipboard and hit OK

4. The response will be automatically recognized and converted to a table by PowerBI. You can hit “Close&Apply”

5. Build your custom Dashboards!