Configuring beSECURE to integrate with Power BI

To integrate beSECURE with Power BI, do the following:

  1. Log in to beSECURE with administrative privileges.
  2. In the upper-left corner of the Home page, select DevOps.
  3. Select Admin > Accounts > List.
  4. Select your account from the list.
  5. Select the API Key tab.
  6. In the API Key box, click your pointer to generate your API key. Make note of 36-character alphanumeric key as you will add it to Power BI in a later step.
  7. From the beSECURE left-side panel, select Admin > Organizations > List.
  8. Select the organization you want to pull results from in Power BI from the list.
  9. Under the Settings tab, make note of the eight-character alphanumeric ID at the top of the page. You will add this ID to Power BI in a later step.

 

Configuring Power BI to integrate with beSECURE

To integrate Power BI with beSECURE, do the following:

  1. From the Power BI ribbon, select Get data > Web.
  2. Paste the following URL, and then replace your_ip with your FQDN/IP address of your beSECURE server, APIKEY with your 36-digit beSECURE API key, and ENTERPRISEwith the eight-digit beSECURE Organization ID:
    https://your_ip/json.cgi?primary=vulnerabilities&secondary=detailed&action=returnvulnerabilities&direction=down&direction=down&order=riskfactor&order=scandate&search_enterprise=ENTERPRISE&search_limit=10000&apikey=APIKEY
    Example:
https://192.168.0.1/json.cgi?primary=vulnerabilities&secondary=detailed&action=returnvulnerabilities&direction=down&direction=down&order=riskfactor&order=scandate&search_enterprise=68857214&search_limit=10000&apikey=97C705C2-F1F6-31F7-B7F1-AA7F11FC0C1B
  3. Select OK. The Power Query Editor window will appear.
  4. On the data row, select List.
  5. From the ribbon, select To Table.
  6. On the To Table dialog, do the following:
    1. In the Select or enter delimiter box, select None.
    2. In the How to handle extra columns box, select Show as errors.
  7. Select OK.
  8. Select the double arrow button.
  9. In the dialog, select the (Select All Columns), Added, AffectedEnterprise, AffectedHost, AffectedNetwork, and Use original column name as prefix checkboxes.
  10. Select OK.
  11. From the ribbon, select Close & Apply. Your beSECURE data is now imported into Power BI and ready for further analysis.