2027 This feature is in development. Join the early-access waitlist below. Expected GA: Q1 2027
📊 BI Connector

Connect AssurAI to
your BI tools.

Export your GRC data to Power BI, Tableau, Looker and Qlik with pre-built data models, live connectors and audit-ready schemas — no data engineering required.

📄 View API docs
📡 Supported tools
Four connectors. One data model.
Pre-certified connectors for the BI tools your organisation already uses. Pull live data from AssurAI without writing a single query.
Power BI
2027
Microsoft's enterprise BI platform with native AssurAI certified connector.
Risk heat maps & KRIs
Control effectiveness trends
Findings aging & status
SOX compliance dashboard
Board-ready reporting
Tableau
2027
Salesforce Tableau with native AssurAI data source connector.
Audit universe visualisation
Population sampling charts
Risk register drill-down
Multi-entity rollups
Custom calculated fields
Looker
2027
Google Looker with pre-built LookML models for GRC reporting.
LookML data models included
Evidence coverage metrics
Control owner workload
Remediation SLA tracking
Embedded Looker Studio
Qlik
2027
Qlik Sense with associative data model for GRC analytics.
Associative GRC analysis
Vendor risk dashboards
IT control population views
Qlik AutoML risk scoring
Direct Query support
⚙️ How it works
Live data. Zero ETL.
AssurAI maintains a live read-only API endpoint your BI tool connects to directly — no exports, no SFTP, no data pipelines to maintain.
01
Authenticate once
Generate a read-only API key in AssurAI Settings. Paste it into your BI connector — no IT team needed.
02
Import pre-built models
Download our certified data model for your BI tool. Controls, findings, risks and evidence are already joined and typed correctly.
03
Publish dashboards
Use our sample reports as a starting point or build from scratch. Data refreshes on your schedule — hourly to real-time.
🗄️ Pre-built data models
Download schemas for your BI tool.
Every AssurAI entity comes with a typed, documented schema — ready to drop into Power BI, Tableau, Looker or Qlik.
🗂️
Controls
assurai_controls
control_id uuid -- primary key control_ref varchar(50) -- e.g. SOX-CTL-001 name text process varchar(100) type varchar(50) -- manual/automated frequency varchar(50) owner_name text risk_rating varchar(20) -- high/medium/low sox_key boolean status varchar(30) last_tested_at timestamptz test_result varchar(30) -- effective/deficient org_id uuid
⚠️
Findings
assurai_findings
finding_id uuid -- primary key ref varchar(50) -- e.g. FIND-2026-001 title text severity varchar(20) -- critical/high/med/low status varchar(30) -- open/in_progress/closed control_id uuid -- FK → controls root_cause text management_resp text due_date date owner_name text opened_at timestamptz closed_at timestamptz days_open integer -- computed org_id uuid
📈
Risk Register
assurai_risks
risk_id uuid -- primary key risk_ref varchar(50) -- e.g. RISK-001 name text category varchar(100) inherent_score numeric(4,2) residual_score numeric(4,2) likelihood integer -- 1–5 impact integer -- 1–5 risk_owner text treatment varchar(50) -- accept/mitigate/transfer control_count integer -- computed kri_threshold numeric(4,2) last_reviewed date org_id uuid
🌐
Audit Universe
assurai_audit_universe
entity_id uuid -- primary key entity_name text entity_type varchar(50) -- process/department/system auditable_unit text risk_score numeric(4,2) audit_cycle varchar(20) -- annual/biennial last_audit_date date next_audit_date date audit_status varchar(30) findings_count integer -- computed controls_count integer -- computed owner_name text org_id uuid
🔗 Connection string generator
Generate your connection string.
Select your BI tool to get a pre-formatted connection string ready to paste. Replace YOUR_API_KEY with a key from AssurAI Settings.
Select a BI tool above to generate your connection string.
🖥️ Sample dashboards
Ready-made reports, included.
Download our starter dashboard templates — drop them into your BI tool and connect to your live AssurAI data.
SOX Controls Dashboard
■ Controls Tested: 142 / 156 Pass rate: 91% Risk distribution:
High (SOX) 72%
Medium 54%
Low 38%
Key deficiencies: 3 open Overdue remediation: 1
Risk Heat Map
■ Active risks: 38 Above threshold: 7 Residual risk by category:
Financial 8.0
Cyber 6.5
Operational 5.0
KRI breaches this month: 2
Findings Aging Report
■ Open findings: 24 Critical: 3 Days open buckets:
0–30 days 14
31–90 days 7
90+ days 3
Avg days to close: 47
Audit Universe Coverage
■ Auditable units: 64 Covered: 89% Coverage by type:
Financial 95%
IT / ITGC 88%
Operational 76%
Overdue audits: 4
📊

Be first to connect.

Join 340+ audit leaders already on the BI Connector waitlist. We'll notify you when your BI tool connector is available for early access.

✅ You're on the list! We'll be in touch.
340 audit leaders already waiting · Expected GA: Q1 2027