> For the complete documentation index, see [llms.txt](https://docs.orkestra.online/orkestra-online/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.orkestra.online/orkestra-online/orkestra-web-api/connecting-analytics-to-powerbi.md).

# Connecting Analytics to PowerBI

###

> :warning: This endpoint will be deprecated on December 1st 2026. Please use the Public Analytics Api instead :warning:

### 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](/files/-MkM0cjzDS42lbU_tn_2)

{% hint style="info" %}
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.
{% endhint %}

### In PowerBI

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

![](/files/-MkM1lnM7gwXHV_Uttog)

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

![](/files/-MkM1yWf2axUD0r67Dkk)

#### 3. Paste the Url from your clipboard and hit OK

<figure><img src="/files/tSlPuMhnyKBS3lvFsGlR" alt=""><figcaption></figcaption></figure>

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

![](/files/-MkM2ksUEj5xYJYMC6md)

#### 5. Build your custom Dashboards!

![](/files/-MkM90YQit6lQgHjtldV)

##