Daily Usage and Cost Tables
Exposes daily token usage, request volume, and cost as typed Power BI tables.
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
Exposes daily token usage, request volume, and cost as typed Power BI tables.
Supports OpenAI organization admin APIs and Anthropic organization admin APIs from one connector entry point.
Breaks usage down by model with input tokens, output tokens, total tokens, and requests.
Provides separate tables for usage by API key, provider project, and service tier when the provider API returns those dimensions.
Uses Power BI Key authentication so provider admin keys are entered through the credential prompt instead of stored in source files.
Uses a stable data source kind, static base URLs, relative paths, typed schemas, and retry handling for common transient API failures.
Included Capabilities
Connector inputs
Inputs and tables aligned to LLM operations.
Select OpenAI (Organization Admin API) or Anthropic (Organization Admin API only) from the connector prompt.
Use an organization admin key with access to usage and cost reporting APIs. Standard runtime API keys are not enough.
Load Usage, Costs, Models, UsageByApiKey, UsageByProject, and UsageByServiceTier into Power BI.
Security Signal
The LLMUsageConnector repository scan reported 0 issues across monitored security checks.
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
Get the connector