Bitsight Security Ratings
Note
The following connector article is provided by Bitsight, the owner of this connector and a member of the Microsoft Power Query Connector Certification Program. If you have questions regarding the content of this article or have changes you would like to see made to this article, visit the Bitsight website and use the support channels there.
Summary
| Item | Description |
|---|---|
| Release State | General Availability |
| Products | Power BI (Semantic models) Power BI (Dataflows) Fabric (Dataflow Gen2) |
| Authentication Types Supported | API key |
| Function Reference Document | — |
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.
Capabilities supported
- Import
Connect to Bitsight from Power BI 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 issues
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.