Adding the HEIMDAL API into Microsoft Power BI

In this article, you will learn how to ingest data from the HEIMDAL API into Microsoft Power BI.

1. From the Microsoft Power BI window, click on Get Data -> Web.

2. Select Advanced radio button and fill in the fields.
3. For URL Parts, type in the Heimdal API that you want to get and click Ok.

First URL part: https://dashboard.heimdalsecurity.com/api/heimdalapi/2.0/activeclients?
Second URL part: customerId=229584&startDate=2026-06-06T00:00:00&endDate=2026-07-06T23:59:59
HTTP request header parameters: Authorization followed by Bearer Your-Personal-Key

4. Click on Connect to ingest that data from the Heimdal API.

Displaying the data ingested from the HEIMDAL Security API

Once the data has been retrieved from the Heimdal API, you can display it in a table similar to the one below:

Things to watch out for:

Drop the optional placeholders. pageNumber, pageSize, and especially clientInfoId are optional — leave them out. Sending clientInfoId={clientInfoId} (or empty) will break the call. Omit them and you get page 1, up to 1000 rows, all clients.
Use recent dates. 2.0 allows a max 31-day window. Your example dates (April–May) are too far back and 2.0 will reject or clamp them — use a window inside the last 31 days like above.
Full timestamps. Use YYYY-MM-DDTHH:MM:SS (with seconds), e.g. 2026-06-06T00:00:00.
Response is wrapped. 2.0 returns { items: [...], totalCount, pageNumber, pageSize } instead of a plain list. After you click OK, click into the items field to expand the actual rows.
One page only. This manual method returns just the first 1000 rows; for more you'd add &pageNumber=2, etc., and repeat.

Here is a video tutorial on how to add the HEIMDAL API into Microsoft Power BI: