Power BI
Microsoft Power BI is a business analytics service that delivers insights to enable fast, informed decisions. It provides interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
Power BI publishes 37 API contracts indexed on the APIs.io network, including Dashboards API, Datasets API, Gateways API, and 34 more. Tagged areas include Analytics, Business Intelligence, Dashboards, Data Analysis, and Reporting.
The Power BI catalog on APIs.io includes 2 JSON-LD contexts and 3 Spectral governance rulesets.
Power BI’s developer surface includes getting-started guide, authentication, sandbox, changelog, CLI, developer portal, engineering blog, and 73 more developer resources.
What this lets a business do 1
Business capabilities this provider's published APIs can perform, derived from its own contracts. Browse all capabilities →
What people ask Power BI 16
The questions people put to an LLM, and the jobs they hand an agent, that Power BI's APIs answer — each one linked to the operation that does it. Generated by API Evangelist
Showing 12 of 16 APIs with phrasing — see every API.
Kin Score
Markets this provider is in provisional
The Kin Score Market layer reads a provider inside its market: its position, and how deep its integrations go. Depth is only comparable within a position. Provisional and unweighted: not part of the Kin Score or agent readiness.
| Market | Position | Depth | Registered MCP server | Declares compatibility |
|---|---|---|---|---|
| Business Intelligence, Analytics and Visualization | gravity | 51.8 | - | - |
| Smartsheet Marketplace (connectors and partner-built solutions on Smartsheet) | gravity | 51.8 | - | - |
Registered MCP server and declares compatibility are report only — not weighted. Undeclared means we found nothing we can read, so there is no number: we never infer integrations.
Standards implemented 2
Standards this provider implements or carries. De facto ones are profiled and measured by the API Commons; formal ones come from the standards directory and are linked by the provider's own tags. The evidence column says how each claim was established — not that it was made.
APIs 37
Individual APIs this provider publishes, each with its own machine-readable definition.
Power BI Authoring MCP Server
Microsoft-hosted (preview) and local stdio (GA) MCP server that lets AI agents create, change, validate and document Power BI semantic models, run DAX, and work with TMDL and PB...
Power BI Consumption MCP Server
Remote MCP endpoint (preview) where AI agents query Power BI semantic models in natural language, generating and executing DAX under the user's permissions.
Power BI Embedded
Azure service that enables ISVs and developers to embed Power BI visuals, reports, and dashboards into their applications.
Power BI Management API
API for managing Power BI capacity, workspaces, and tenant settings.
Power BI Push Datasets API
The Push Datasets API enables real-time data streaming by allowing applications to create push datasets and post rows of data directly into Power BI datasets.
Power BI Report Server REST API
The Power BI Report Server REST API provides programmatic access to report server catalog objects such as folders, reports, KPIs, data sources, datasets, refresh plans, and subs...
Power BI Visuals API
The Power BI Visuals API enables developers to create custom visuals that can be used in Power BI reports and dashboards, extending the built-in visualization capabilities.
Power BI Dashboards API
Manage dashboards including listing, creating, and retrieving tiles. Dashboards are single-page canvases with pinned visualizations.
Power BI Datasets API
Manage datasets including creating, updating, refreshing, and deleting datasets. Datasets represent the data model behind Power BI reports.
Power BI Gateways API
Manage on-premises data gateways and their data sources for connecting to on-premises data.
Power BI Groups API
Manage workspaces (groups) including listing, creating, deleting, and managing workspace users. Workspaces are containers for dashboards, reports, datasets, and dataflows.
Power BI Imports API
Import Power BI content such as PBIX files, Excel workbooks, and RDL reports into workspaces.
Power BI Reports API
Manage reports including listing, cloning, exporting, rebinding, and deleting reports. Reports are visual presentations of data from datasets.
Power BI Embedded API
Power BI Embedded enables developers to embed interactive Power BI reports, dashboards, and tiles into custom applications. It provides client-side JavaScript APIs for rendering...
Microsoft Power BI Apps API
The Apps API from Microsoft Power BI — 1 operation(s) for apps.
Microsoft Power BI Capacities API
The Capacities API from Microsoft Power BI — 1 operation(s) for capacities.
Microsoft Power BI Dashboards API
The Dashboards API from Microsoft Power BI — 2 operation(s) for dashboards.
Microsoft Power BI Dataflows API
The Dataflows API from Microsoft Power BI — 1 operation(s) for dataflows.
Microsoft Power BI Datasets API
The Datasets API from Microsoft Power BI — 5 operation(s) for datasets.
Microsoft Power BI EmbedToken API
The EmbedToken API from Microsoft Power BI — 1 operation(s) for embedtoken.
Microsoft Power BI Gateways API
The Gateways API from Microsoft Power BI — 1 operation(s) for gateways.
Microsoft Power BI Groups API
The Groups API from Microsoft Power BI — 2 operation(s) for groups.
Microsoft Power BI Imports API
The Imports API from Microsoft Power BI — 1 operation(s) for imports.
Microsoft Power BI Reports API
The Reports API from Microsoft Power BI — 5 operation(s) for reports.
Power BI Admin API
The Admin API from Power BI — 55 operation(s) for admin.
Power BI Available Features API
The AvailableFeatures API from Power BI — 2 operation(s) for availablefeatures.
Power BI Dataflow Storage Accounts API
The DataflowStorageAccounts API from Power BI — 2 operation(s) for dataflowstorageaccounts.
Power BI Goal Notes (Preview) API
The GoalNotes_(Preview) API from Power BI — 2 operation(s) for goalnotes_(preview).
Power BI Goals (Preview) API
The Goals_(Preview) API from Power BI — 7 operation(s) for goals_(preview).
Power BI Goals Status Rules (Preview) API
The GoalsStatusRules_(Preview) API from Power BI — 1 operation(s) for goalsstatusrules_(preview).
Power BI Goal Values (Preview) API
The GoalValues_(Preview) API from Power BI — 2 operation(s) for goalvalues_(preview).
Power BI Pipelines API
The Pipelines API from Power BI — 12 operation(s) for pipelines.
Power BI Profiles API
The Profiles API from Power BI — 2 operation(s) for profiles.
Power BI Push Datasets API
The PushDatasets API from Power BI — 8 operation(s) for pushdatasets.
Power BI Scorecards (Preview) API
The Scorecards_(Preview) API from Power BI — 4 operation(s) for scorecards_(preview).
Power BI Template Apps API
The TemplateApps API from Power BI — 1 operation(s) for templateapps.
Power BI Users API
The Users API from Power BI — 1 operation(s) for users.
Scroll for all 37
Postman Collections 6
Ready-to-run Postman collections for exercising this provider's APIs.
Power BI REST Dashboards API
POSTMANOpen Collections 7
Open, tool-agnostic API collections (OpenAPI-derived and Bruno).
Power BI REST Dashboards API
OPEN COLLECTIONPower BI REST Dashboards Datasets API
OPEN COLLECTIONPower BI REST Dashboards Gateways API
OPEN COLLECTIONPower BI REST Dashboards Groups API
OPEN COLLECTIONPower BI REST Dashboards Imports API
OPEN COLLECTIONPower BI REST Dashboards Reports API
OPEN COLLECTIONPower BI REST API
OPEN COLLECTIONScroll for all 7
Arazzo Workflows 12
Multi-step API workflows described with the Arazzo specification.
Power BI Resolve a Dashboard Tile for Embedding
Walk from the dashboard list down to a single tile and capture the embed URL, report, and dataset it needs.
ARAZZOPower BI Decommission a Dataset After Clearing Dependents
Confirm a dataset, find the reports bound to it, delete the dependent report, and then delete the dataset.
ARAZZOPower BI Trigger a Dataset Refresh and Poll to Completion
Kick off an on-demand dataset refresh and poll the refresh history until it reaches a terminal state.
ARAZZOPower BI Audit Gateway-Bound Datasources
Walk the gateway inventory and cross-reference a dataset's datasources to prove which gateway backs it.
ARAZZOPower BI Update Dataset Parameters and Refresh
Read a dataset's mashup parameters, update them, confirm the new values, and refresh so the change takes effect.
ARAZZOPower BI Import a PBIX and Poll Until Published
Upload a PBIX file into a workspace, wait for the import to finish publishing, and list the resulting reports and datasets.
ARAZZOPower BI Create a Push Dataset and Verify Its Schema
Provision a push-mode dataset with an inline table schema and read it back to confirm the row API is enabled.
ARAZZOPower BI Clone a Report and Rebind It to Another Dataset
Copy a report into a target workspace and repoint the copy at a different dataset, then verify the binding.
ARAZZOPower BI Export a Report for Archive
Capture a report's metadata and page structure, then download the underlying PBIX file.
ARAZZOPower BI Review and Adjust Workspace Access
List a workspace's members, downgrade an over-privileged principal, remove a departed one, and confirm the final membership.
ARAZZOPower BI Inventory a Workspace's Content
Find a workspace by OData filter and enumerate every dataset, report, dashboard, and import it contains.
ARAZZOPower BI Provision a Workspace and Grant Access
Create a workspace, add a principal with a specific access right, and verify the resulting membership.
ARAZZOScroll for all 12
Power BI API pricing
Prices published by Power BI, read 2026-10-28 from azure.microsoft.com/en-us/pricing/details/power-bi-embedded/.
| Plan | Price |
|---|---|
| A1 | $- |
| A2 | $- |
| A3 | $- |
| A4 | $- |
| A5 | $- |
| A6 | $- |
| A7 | $- |
| A8 | $- |
Plan details, limits and sources →
Rate limits
- POST rows requests per minute: 120 POST rows requests per minute per semantic model
- Rows added per hour: 1,000,000 rows added per hour per semantic model
- Rows per POST: 10,000 max rows per single POST rows request
Pricing Plans 1
Published pricing tiers and plan structures.
Rate Limits 1
Documented rate limits and quota policies.
Power Bi Rate Limits
RATE LIMITSService Levels 1
Uptime the provider promises or reports, as SLA4OAI. Read from its own pages; APIs.io runs no monitors.
Power BI
SLAFinOps 1
Cost, billing, and metering signals for API financial operations.
Power Bi Finops
FINOPSFeatures 8
Notable capabilities this provider offers.
Interactive Dashboards
Create and share interactive dashboards with real-time data visualizations and drill-down capabilities.
Natural Language Queries
Ask questions about your data in plain English and get instant visualizations with Q&A.
Data Connectivity
Connect to hundreds of data sources including databases, cloud services, files, and streaming data.
Embedded Analytics
Embed Power BI reports and dashboards into custom applications using REST APIs and JavaScript SDK.
Paginated Reports
Create pixel-perfect, print-ready reports designed for printing or PDF generation.
Real-Time Streaming
Push real-time data to dashboards with streaming datasets and live tile updates.
Row-Level Security
Control data access at the row level based on user identity and roles.
Dataflows
Self-service data preparation with Power Query Online for creating reusable data transformation logic.
Scroll for all 8
Semantic Vocabularies 2
JSON-LD contexts and semantic vocabularies used across these APIs.
Power Bi Context
JSON-LDPower Bi Rest Context
JSON-LDSpectral Rules 3
Spectral governance rulesets for linting and validating these APIs.
OpenAPI Overlays 11
Overlays applied on top of this provider's contracts. Each card says who wrote it: a document the provider publishes, or one API Evangelist derived or generated.
Power Bi Apps Api Phrasing Overlay
GENERATEDPower Bi Capacities Api Phrasing Overlay
GENERATEDPower Bi Dashboards Api Phrasing Overlay
GENERATEDPower Bi Dataflows Api Phrasing Overlay
GENERATEDPower Bi Datasets Api Phrasing Overlay
GENERATEDPower Bi Embedtoken Api Phrasing Overlay
GENERATEDPower Bi Gateways Api Phrasing Overlay
GENERATEDPower Bi Groups Api Phrasing Overlay
GENERATEDPower Bi Imports Api Phrasing Overlay
GENERATEDPower Bi Reports Api Phrasing Overlay
GENERATEDPower Bi Rest Api Overlay
DERIVEDScroll for all 11
JSON Schema 95
Standalone JSON Schema definitions for this provider's data models.
CloneReportRequest
JSON SCHEMACloneReportRequest
JSON SCHEMAColumn
JSON SCHEMACreateDashboardRequest
JSON SCHEMACreateDatasetRequest
JSON SCHEMACreateDashboardRequest
JSON SCHEMACreateDatasetRequest
JSON SCHEMACreateGroupRequest
JSON SCHEMADashboardList
JSON SCHEMADashboard
JSON SCHEMADashboardList
JSON SCHEMADatasetList
JSON SCHEMAPower BI Dataset
JSON SCHEMADatasetList
JSON SCHEMADatasource
JSON SCHEMADatasourceList
JSON SCHEMAErrorResponse
JSON SCHEMAGatewayDatasourceList
JSON SCHEMAGatewayList
JSON SCHEMAGateway
JSON SCHEMAGatewayDatasource
JSON SCHEMAGatewayDatasourceList
JSON SCHEMAGatewayList
JSON SCHEMAGenericList
JSON SCHEMAGenericObject
JSON SCHEMAGroupList
JSON SCHEMAGroup
JSON SCHEMAGroupUser
JSON SCHEMAGroupList
JSON SCHEMAGroupUser
JSON SCHEMAGroupUserList
JSON SCHEMAImportList
JSON SCHEMAImport
JSON SCHEMAImportList
JSON SCHEMAMeasure
JSON SCHEMAPageList
JSON SCHEMAPage
JSON SCHEMAPageList
JSON SCHEMAParameter
JSON SCHEMAParameterList
JSON SCHEMARebindReportRequest
JSON SCHEMARebindReportRequest
JSON SCHEMARefreshList
JSON SCHEMARefreshRequest
JSON SCHEMARefresh
JSON SCHEMARefreshList
JSON SCHEMARefreshRequest
JSON SCHEMARelationship
JSON SCHEMAReportList
JSON SCHEMAPower BI Report
JSON SCHEMAReportList
JSON SCHEMACloneReportRequest
JSON SCHEMAColumn
JSON SCHEMACreateDashboardRequest
JSON SCHEMACreateDatasetRequest
JSON SCHEMACreateGroupRequest
JSON SCHEMADashboardList
JSON SCHEMADashboard
JSON SCHEMADatasetList
JSON SCHEMADataset
JSON SCHEMADatasourceList
JSON SCHEMADatasource
JSON SCHEMAErrorResponse
JSON SCHEMAGatewayDatasourceList
JSON SCHEMAGatewayDatasource
JSON SCHEMAGatewayList
JSON SCHEMAGateway
JSON SCHEMAGroupList
JSON SCHEMAGroup
JSON SCHEMAGroupUserList
JSON SCHEMAGroupUser
JSON SCHEMAImportList
JSON SCHEMAImport
JSON SCHEMAMeasure
JSON SCHEMAPageList
JSON SCHEMAPage
JSON SCHEMAParameterList
JSON SCHEMAParameter
JSON SCHEMARebindReportRequest
JSON SCHEMARefreshList
JSON SCHEMARefreshRequest
JSON SCHEMARefresh
JSON SCHEMARelationship
JSON SCHEMAReportList
JSON SCHEMAReport
JSON SCHEMATable
JSON SCHEMATileList
JSON SCHEMATile
JSON SCHEMAUpdateParametersRequest
JSON SCHEMATable
JSON SCHEMATileList
JSON SCHEMATile
JSON SCHEMATileList
JSON SCHEMAUpdateParametersRequest
JSON SCHEMAUpdateParametersRequest
JSON SCHEMAScroll for all 95
JSON Structure 39
JSON Structure definitions describing this provider's data shapes.
Power Bi Rest Clone Report Request Structure
JSON STRUCTUREPower Bi Rest Column Structure
JSON STRUCTUREPower Bi Rest Create Dashboard Request Structure
JSON STRUCTUREPower Bi Rest Create Dataset Request Structure
JSON STRUCTUREPower Bi Rest Create Group Request Structure
JSON STRUCTUREPower Bi Rest Dashboard List Structure
JSON STRUCTUREPower Bi Rest Dashboard Structure
JSON STRUCTUREPower Bi Rest Dataset List Structure
JSON STRUCTUREPower Bi Rest Dataset Structure
JSON STRUCTUREPower Bi Rest Datasource List Structure
JSON STRUCTUREPower Bi Rest Datasource Structure
JSON STRUCTUREPower Bi Rest Error Response Structure
JSON STRUCTUREPower Bi Rest Gateway Datasource List Structure
JSON STRUCTUREPower Bi Rest Gateway Datasource Structure
JSON STRUCTUREPower Bi Rest Gateway List Structure
JSON STRUCTUREPower Bi Rest Gateway Structure
JSON STRUCTUREPower Bi Rest Group List Structure
JSON STRUCTUREPower Bi Rest Group Structure
JSON STRUCTUREPower Bi Rest Group User List Structure
JSON STRUCTUREPower Bi Rest Group User Structure
JSON STRUCTUREPower Bi Rest Import List Structure
JSON STRUCTUREPower Bi Rest Import Structure
JSON STRUCTUREPower Bi Rest Measure Structure
JSON STRUCTUREPower Bi Rest Page List Structure
JSON STRUCTUREPower Bi Rest Page Structure
JSON STRUCTUREPower Bi Rest Parameter List Structure
JSON STRUCTUREPower Bi Rest Parameter Structure
JSON STRUCTUREPower Bi Rest Rebind Report Request Structure
JSON STRUCTUREPower Bi Rest Refresh List Structure
JSON STRUCTUREPower Bi Rest Refresh Request Structure
JSON STRUCTUREPower Bi Rest Refresh Structure
JSON STRUCTUREPower Bi Rest Relationship Structure
JSON STRUCTUREPower Bi Rest Report List Structure
JSON STRUCTUREPower Bi Rest Report Structure
JSON STRUCTUREPower Bi Rest Table Structure
JSON STRUCTUREPower Bi Rest Tile List Structure
JSON STRUCTUREPower Bi Rest Tile Structure
JSON STRUCTUREPower Bi Rest Update Parameters Request Structure
JSON STRUCTUREPower Bi Structure
JSON STRUCTUREScroll for all 39
Examples 74
Example request and response payloads for these APIs.
Power Bi Clonereport Example
EXAMPLEPower Bi Creategroup Example
EXAMPLEPower Bi Deletegroup Example
EXAMPLEPower Bi Getdataset Example
EXAMPLEPower Bi Getdatasets Example
EXAMPLEPower Bi Getgateway Example
EXAMPLEPower Bi Getgateways Example
EXAMPLEPower Bi Getgroups Example
EXAMPLEPower Bi Getpages Example
EXAMPLEPower Bi Getreport Example
EXAMPLEPower Bi Getreports Example
EXAMPLEPower Bi Gettile Example
EXAMPLEPower Bi Gettiles Example
EXAMPLEPower Bi Rest Column Example
EXAMPLEPower Bi Rest Group Example
EXAMPLEPower Bi Rest Import Example
EXAMPLEPower Bi Rest Page Example
EXAMPLEPower Bi Rest Report Example
EXAMPLEPower Bi Rest Table Example
EXAMPLEPower Bi Rest Tile Example
EXAMPLEScroll for all 74
Security Posture 4
Authentication, domain security, vulnerability disclosure, and trust-center signals.
Scopes 1
OAuth scopes governing access to this provider's APIs.
Agentic Access 1
Recommended x-agentic-access execution contracts for AI agents.
Use Cases 6
What developers build with this provider.
Executive Dashboards
Provide C-suite executives with real-time KPI dashboards for data-driven decision making.
Sales Analytics
Track sales performance, pipeline metrics, and revenue forecasting with interactive reports.
Financial Reporting
Automate financial reporting with scheduled refreshes and pixel-perfect paginated reports.
Embedded Analytics for ISVs
Embed Power BI visualizations into SaaS applications to provide analytics to end customers.
IoT Monitoring
Visualize real-time IoT sensor data with streaming datasets and live dashboard tiles.
HR Analytics
Analyze workforce metrics, retention rates, and employee engagement across the organization.
Integrations 8
Pre-built integrations with other platforms and tools.
Microsoft Teams
View and interact with Power BI reports directly within Microsoft Teams channels and chats.
Excel
Analyze Power BI datasets in Excel with connected tables and PivotTables.
SharePoint
Embed Power BI reports in SharePoint Online pages for enterprise-wide distribution.
Azure Synapse Analytics
Connect to Azure Synapse workspaces for big data analytics and data warehousing.
Dynamics 365
Pre-built analytics templates and data connectors for Dynamics 365 business applications.
Power Automate
Trigger automated workflows based on Power BI data alerts and refresh events.
Azure Active Directory
Enterprise authentication and authorization with Azure AD for secure API access.
Salesforce
Connect to Salesforce data with native connectors for CRM analytics and reporting.
Scroll for all 8
Resources
Get Started 6
Portal, sign-up, and the first successful call
Documentation 4
Reference material describing how the API behaves
Agent Surfaces 5
MCP servers, agent skills, and machine-readable catalogs
Design & Contract 23
Pagination, idempotency, versioning, errors, and events
Scroll for all 23
Build 9
SDKs, sample code, and the tooling you integrate with
Scroll for all 9
Access & Security 8
Authentication, authorization, and security posture
Scroll for all 8
Learn 1
Tutorials, courses, talks, and written guidance
Operate 10
Status, limits, changes, and where to get help
Scroll for all 10
Commercial 5
Pricing, plans, and the legal terms of use
Company 3
The organization behind the API
Other 6
Properties that don't map to a standard resource type
Source (apis.yml)
Power BI API — frequently asked questions
Does Power BI have an API?
Yes. APIs.io lists 37 APIs from Power BI, including Power BI Authoring MCP Server, Power BI Consumption MCP Server and Power BI Embedded, and 34 more.
Is there an OpenAPI specification for the Power BI API?
Yes. APIs.io indexes 29 OpenAPI specifications for Power BI, each linked for download from this page.
How do I authenticate with the Power BI API?
Power BI uses bearer-token authentication (http/oauth2 · 1 scheme). The details are profiled on APIs.io as Power Bi Authentication.
How much does the Power BI API cost?
Power BI publishes its prices; its A1 plan is $- as of 2026-10-28. APIs.io lists 8 pricing plans for Power BI, with each plan's price, limits and inclusions under Pricing on this page.
Is the Power BI API ready for AI agents?
Power BI has a Kin Score of 78.3 out of 100 (exemplar) and an Agent Readiness score of 30.6 (agent-ready), scored by API Evangelist on 2026-11-06.
Work with this as data
Every provider here is available over the APIs.io API and to AI agents over MCP.