This guide will explain how to get data from the CyberPilot Report API into PowerBI.
Import data
Click "Get data" and select "Web"
.png?width=441&height=554&name=image%20(13).png)
Click "Advanced" and input the URL for the API endpoint from which you wish to get data.
Remember to replace {account-id} in the URL with your account ID.
Add an Authorization header, and set its value to Bearer followed by your long-lived access token, ie. Bearer eyJhbGciOiJIUzI1NiIsInR5...
.png?width=670&height=457&name=image%20(14).png)
Click OK and wait for the editor the fetch the data.
Now, you can drill down and expand the data to extract the information you need:
.png?width=670&height=213&name=image%20(15).png)
Still have a question?
Contact us at support@cyberpilot.io