Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Note
This connector is owned and provided by Bitsight.
Summary
| Property | Value |
|---|---|
| Connector |  Bitsight Security Ratings |
| Products | Power BI (semantic models) Power Query Online |
| Release state | General availability |
| Category | Other |
| Authentication kinds | API Authentication |
| Data source kind | BitSightSecurityRatings |
| Function Reference Documentation | BitSightSecurityRatings.Contents |
| Support link | Contact the connector owner. |
Prerequisites
A user must have a Bitsight Security Ratings product in order to access the Bitsight data in Power BI. For more information on Bitsight Security Ratings, go to https://www.bitsight.com/security-ratings.
Users must also have the March 2021 release of Power BI Desktop or later.
Supported capabilities
- Import
Parameters
Entry point: BitSightSecurityRatings.Contents
Required parameter count: 0
| Parameter | Required | Type | Nullable |
|---|---|---|---|
| company_guid | No | nullable text | true |
| affects_rating_findings | No | nullable logical | true |
Connect from Power Query Desktop
To connect to Bitsight:
Retrieve API token from Bitsight.
In Power BI Desktop, select Get Data from the Home ribbon, select More from the drop down, and search for Bitsight.
If this is the first time you're getting the data through the Bitsight connector, a prompt appears to inform you of the connection to a third-party service.
Place your Bitsight API token in Power BI. In the Window that appears, provide your credentials.
Once the connection is established, you can preview and select multiple data points in the Navigator dialog box to create an output.
You can Load the selected table, which brings the entire table into Power BI Desktop, or you can select Transform Data to edit the query, which opens the Power Query editor. You can then filter and refine the set of data you want to use, and then load that refined set of data into Power BI Desktop.
Limitations and considerations
Bitsight for Security Performance Management
Can only view data on one company at a time, and assumes the parent company. The parent company can be changed.