Power BI Custom Connector LLM Usage Monitoring Free Beta connector

LLM Usage Monitor (Power BI Custom Connector)

A Power BI connector for the token and cost data behind AI usage.

A beta Power BI custom connector for LLM usage monitoring that helps analysts track organization-level token usage, model consumption, request volume, and cost across OpenAI and Anthropic admin APIs.

Features

Daily Usage and Cost Tables

Exposes daily token usage, request volume, and cost as typed Power BI tables.

Provider Selection

Supports OpenAI organization admin APIs and Anthropic organization admin APIs from one connector entry point.

Model-Level Visibility

Breaks usage down by model with input tokens, output tokens, total tokens, and requests.

API Key, Project, and Service Tier Views

Provides separate tables for usage by API key, provider project, and service tier when the provider API returns those dimensions.

Power BI Credential Store Authentication

Uses Power BI Key authentication so provider admin keys are entered through the credential prompt instead of stored in source files.

Refresh-Oriented Connector Design

Uses a stable data source kind, static base URLs, relative paths, typed schemas, and retry handling for common transient API failures.

Included Capabilities

Free

  • Daily Usage and Cost Tables
  • Provider Selection
  • Model-Level Visibility
  • API Key, Project, and Service Tier Views

Advanced

  • API Key, Project, and Service Tier Views
  • Power BI Credential Store Authentication
  • Refresh-Oriented Connector Design

Connector inputs

Inputs and tables aligned to LLM operations.

Provider

OpenAI or Anthropic

Select OpenAI (Organization Admin API) or Anthropic (Organization Admin API only) from the connector prompt.

Admin API Key

Required

Use an organization admin key with access to usage and cost reporting APIs. Standard runtime API keys are not enough.

Usage Tables

6 tables

Load Usage, Costs, Models, UsageByApiKey, UsageByProject, and UsageByServiceTier into Power BI.

Security Signal

Aikido logo

Aikido Security

The LLMUsageConnector repository scan reported 0 issues across monitored security checks.

0 issues

This scan is a helpful third-party signal for the repository, but it does not replace your organization's own review of beta software, connector behavior, and credential handling.

Use cases

Data Analysts AI Operations BI Developers Finance Operations Platform Teams

Get the connector

Start monitoring LLM usage from Power BI.