API: Integration With PowerBI

This guide will explain how to get data from the CyberPilot Report API into PowerBI.

For the auto-refresh to work when publishing your report to the PowerBI cloud, you will have to hardcode your Long-Lived access token directly into the report.

(link to: https://www.cyberpilot.io/cyberpedia/get-reports-from-cyberpilots-report-api)

Import data

Click "Get data" and select "Blank query"

This will open up the Power Query Editor.

Click Advanced Editor:

Insert this query:

let

    BaseUrl = "https://api.app.cyberpilot.io/",

    RelativePath = "accounts/{account-id}/reports/users-awareness",

    Headers = [Authorization="Bearer {access-token}"],

    Source = Json.Document(Web.Contents(BaseUrl, [RelativePath=RelativePath, Headers=Headers]))

in

Source

Replace the RelativePath with the endpoint you want to connect to, and the {access-token} with your access token.

Click Done and wait for the editor to fetch the data.

API: Integration With PowerBI

How to get data from the CyberPilot Report API into PowerBI.

Import data

Now, you can drill down and expand the data to extract the information you need:

Still have a question?