Overview

The Bitsight Power BI Connector enables users to integrate security and vendor risk data from Bitsight’s APIs directly into Power BI for robust reporting and visualization. Version 4.1.0 extends support for Continuous Monitoring (CM) and introduces new access to Vendor Risk Management (VRM) data via 24 newly integrated API endpoints.

Key Benefits

Enhanced Data Coverage

• Combines data from Bitsight Security Ratings and Vendor Risk Management APIs.

• Includes access to:

  • Portfolio ratings and risk vectors

  • Internal and external vendor assessments

  • Security findings, questionnaires, and lifecycle metadata

User-Centric Navigation

• Connector includes a navigation screen with user-friendly table names and previews.

• Enables selection of tables for import via a guided interface.

Backward Compatibility

• Refactored folder structure ensures compatibility with dashboards built on v3.9.0.

• Prevents broken data paths for users upgrading from earlier versions.

Performance Improvements

• Introduced batch pagination for the Requirements Progress table (in groups of 50 vendor IDs).

• Prevents timeout or URL length issues during large queries.

Integration Capabilities

The connector supports a wide set of Power BI entities, including:

Each entity is schema-mapped and dynamically retrieved via a GetEntity function, ensuring correct parsing and transformation for reporting purposes.

Manual Installation

If the connector is not available through the Microsoft certified list, follow the manual installation steps:

1. Enable Custom Connectors

   • Power BI Desktop → Options & Settings → Security → Enable “Load extensions without validation”

2. Place Connector File

   • Copy the .mez file to:

     • C:\Users\<YourUsername>\Documents\Power BI Desktop\Custom Connectors\ (User scope)

     • C:\Program Files\Microsoft Power BI Desktop\Custom Connectors\ (Admin scope)

3. Restart Power BI Desktop and access it via Get Data > Other > Bitsight Connector.

Prerequisites

To use the connector:

• Power BI Desktop (latest version recommended)

• Bitsight account with an API token

• To generate your API token, log in to your Bitsight account and visit Settings → Account. Scroll to the API Token section and generate a new token.

Performance Considerations

• High-complexity tables (e.g., Vendor Questionnaires) make multiple chained API calls and may experience long load times.

• Users are encouraged to import only the tables they require.

• Pagination has been introduced to mitigate risks of API limits, especially in VRM Requirements Progress.

Documentation and Connector Files

• Microsoft PowerBI Connector Installation Manual
• Microsoft PowerBI Connector Files

This app has gone through the Microsoft certification process.

Connector Certification Process Documentation.

Support

For assistance with setup, API access, or troubleshooting:

• See the Microsoft PowerBI connector manual installation guide

• Contact Bitsight Support:
  /hc/en-us/articles/115000807367-How-to-Get-Help

Appendix

Endpoints

The following API endpoints are supported for continuous monitoring (CM):

/v1/folders

/v1/insights/rating_changes

/v1/portfolio/breaches

/v1/portfolio/ratings

/v1/portfolio/risk-vectors/grades

/v2/portfolio

/v1/tiers