Ctrl+K
tatersecurity.com Open App

Power BI Integration

Connect Microsoft Power BI to live TATER compliance data. Build custom dashboards, executive scorecards, and multi-week trend reports using the TATER compliance data endpoint.

Role required: An API key with Auditor-level access or higher is needed. Generate one under Settings → API Keys.

Overview

TATER exposes a dedicated flat-data endpoint at GET /api/reports/powerbi that returns denormalized JSON tables designed for direct import into Power BI, Excel, or any BI tool that supports web data sources. No transformation, no nested objects — just rows you can use.

The endpoint supports five datasets selectable via the dataset query parameter:

DatasetContentsKey fields
controlsOne row per control per scan type (latest scan per type)controlId, title, application, scanType, status, isOverride, daysUntilOverrideExpiry
scansScan history with pass/fail KPIsscanId, scanDate, scanType, hostname, passCount, failCount, complianceRate
risksRisk register entriesriskId, title, category, likelihood, impact, riskScore, status, owner
overridesAll risk acceptancesoverrideId, controlId, type, expiryDate, daysUntilExpiry, isExpired
overviewSingle aggregate summary rowcomplianceRate, passCount, failCount, openRiskCount, activeOverrideCount, lastScanDate
allAll five datasets in one responseReturns a keyed object: {"controls":[…],"scans":[…],…}

Connect Power BI Desktop

The quickest path is the Web connector in Power BI Desktop. Each dataset is a separate query.

Step 1 — Get your API key

In TATER, go to Settings → API Keys and create or copy an existing key. Keep it handy — you will paste it as a custom HTTP header.

Step 2 — Add a Web data source

  1. In Power BI Desktop, click Home → Get Data → Web.
  2. Select Advanced.
  3. In the URL field, enter the endpoint for the dataset you want:
    https://api.tatersecurity.com/api/reports/powerbi?dataset=controls
  4. Under HTTP request header parameters, add:
    Header: x-api-key  |  Value: your-api-key
  5. If you have multiple organizations, add a second header:
    Header: x-organization-id  |  Value: org-xxxxxxxx
  6. Click OK. Power Query will load the JSON array.
  7. In the Power Query editor, click To Table, then expand the Record column to get individual columns.
  8. Click Close & Apply.
Tip: Repeat steps 2–8 for each dataset (scans, risks, overrides, overview) so you have separate tables to relate in your data model.

Step 3 — Build relationships

The datasets share common fields for building relationships:

  • controls ↔ overrides: controls.controlId = overrides.controlId
  • controls ↔ scans: controls.scanId = scans.scanId

Step 4 — Schedule refresh

Publish your report to Power BI Service. In the dataset settings, configure a Scheduled Refresh. TATER caches the response for 60 seconds, so daily or hourly refresh schedules work without triggering rate limits.

Store your API key as a data source credential in Power BI Service under Data source credentials → Edit credentials → Anonymous → Advanced → Add header.

Connect Excel / Microsoft Fabric

The same Web connector approach works in Excel (Data → From Web) and Microsoft Fabric (Dataflow Gen2 → New source → Web API). Use the same URL and API key header.

Query Parameters Reference

ParameterValuesDefaultNotes
datasetcontrols, scans, risks, overrides, overview, allallSingle-dataset requests return a flat array; all returns a keyed object
statusPass, Fail, Manual, Skip, Error—Filter controls by status. Controls dataset only.
applicationAny compliance zone name—Filter controls by application. Controls dataset only.
limit1–10030Max scans to return. Scans dataset only.

Example URLs

# All datasets
https://api.tatersecurity.com/api/reports/powerbi

# Controls only
https://api.tatersecurity.com/api/reports/powerbi?dataset=controls

# Failing controls only
https://api.tatersecurity.com/api/reports/powerbi?dataset=controls&status=Fail

# Last 90 scans
https://api.tatersecurity.com/api/reports/powerbi?dataset=scans&limit=90

# Overview summary row
https://api.tatersecurity.com/api/reports/powerbi?dataset=overview

Authentication

The endpoint supports two authentication methods:

  • API key (recommended for BI tools): Pass your API key in the x-api-key request header. Include x-organization-id to scope to a specific org.
  • JWT Bearer token: Pass a valid TATER JWT in the Authorization: Bearer <token> header. Requires Auditor role or higher.