Skip to content

Integrating BoostSecurity to Power BI


Learn how to integrate BoostSecurity data into your Power BI seamlessly reports using a GraphQL endpoint.


Overview


BoostSecurity offers a powerful GraphQL API that allows you to retrieve valuable security findings directly into your Power BI dashboard. This integration enables you to analyze and visualize security data efficiently.


Steps


Follow these steps to integrate BoostSecurity with Power BI successfully:

  1. Open Power BI: Launch Power BI on your system.
  2. Get Data from Another Source: Click on "Get data from another source" to initiate the data import process.

    Power BI - Get data from another source

  3. Select Python Script: Choose "Python script" from the available options as your data source.

    Power BI - python script

  4. Paste the Code: Paste the provided Python code into the designated area. > Note: Be sure to replace <YOUR API KEY> with the API key you generated as outlined in the steps provided in the Creating an API Key section.

    If Python is not already installed on your system, you can install the necessary packages by running the following commands in your environment:

    pip install pandas
    pip install matplotlib
    pip3 install requests
    

  5. Load Data: After pasting the code and making the necessary adjustments, click "OK" to load the data.

    Power BI - load data

  6. Generate Tables and Charts: You can use the loaded data to create tables and charts according to your reporting requirements.

    Power BI - sample visualization