Power BI

Power BI Datasets API

Manage datasets including creating, updating, refreshing, and deleting datasets. Datasets represent the data model behind Power BI reports.

GitHub OpenAPI
Business capability
Analytics & BI Management BC-610.50

Operations 10

Each operation below carries the questions people ask an LLM about it and the instructions they give an agent to run it. Generated by API Evangelist overlay

GET /datasets List datasets in My Workspace · Power Bi List Datasets #
Ask an LLM
“What datasets are in my personal My Workspace?”
“Which of my datasets are push datasets and which are refreshable?”
Tell an agent
List the datasets in My Workspace.
Show me which of my My Workspace datasets can be refreshed.
POST /datasets Create a push dataset · Power Bi Create a Push Dataset #
Ask an LLM
“How do I create a push dataset so my app can stream rows into Power BI?”
“Can I define tables and relationships when creating a real-time dataset?”
Tell an agent
Create a push dataset named {name} with tables {tables}.
Create push dataset {name} with tables {tables} and retention policy {defaultRetentionPolicy}.
GET /datasets/{datasetId} Get a dataset's details · Power Bi Get a Dataset #
Ask an LLM
“How can I see the tables and configuration of one dataset?”
“What data source details does a specific dataset have?”
Tell an agent
Get dataset {datasetId}.
Show me the configuration and tables of dataset {datasetId}.
DELETE /datasets/{datasetId} Delete a dataset · Power Bi Delete a Dataset #
Ask an LLM
“How do I delete a dataset from My Workspace?”
“Does removing a dataset also delete the reports and tiles built on it?”
Tell an agent destructive · confirm first
Delete dataset {datasetId}.
Remove dataset {datasetId} along with its dependent reports and tiles.
GET /datasets/{datasetId}/refreshes Check a dataset's refresh history · Power Bi Get Refresh History #
Ask an LLM
“Did my dataset's last refresh succeed or fail?”
“When did a dataset's recent refreshes start and finish?”
Tell an agent
Show the refresh history of dataset {datasetId}.
Get the last {top} refreshes for dataset {datasetId}.
POST /datasets/{datasetId}/refreshes Trigger a dataset refresh · Power Bi Trigger a Dataset Refresh #
Ask an LLM
“How do I kick off a refresh of a dataset on demand?”
“Can I refresh only specific tables or partitions instead of the whole dataset?”
Tell an agent
Refresh dataset {datasetId} now.
Refresh only {objects} in dataset {datasetId}.
GET /datasets/{datasetId}/datasources List a dataset's data sources · Power Bi Get Data Sources #
Ask an LLM
“Which server and database does a dataset pull its data from?”
“What kinds of data sources is a given dataset connected to?”
Tell an agent
List the data sources of dataset {datasetId}.
Show the connection details behind dataset {datasetId}.
GET /datasets/{datasetId}/parameters List a dataset's parameters · Power Bi Get Dataset Parameters #
Ask an LLM
“What parameters does a dataset expose for its connections and queries?”
“Can I view the current parameter values on one dataset?”
Tell an agent
List the parameters of dataset {datasetId}.
Show current parameter values for dataset {datasetId}.
POST /datasets/{datasetId}/parameters Update a dataset's parameter values · Power Bi Update Dataset Parameters #
Ask an LLM
“How do I change a dataset's parameter values, like pointing it at another server?”
“Do new parameter values take effect immediately or after a refresh?”
Tell an agent
Update the parameters of dataset {datasetId} with {updateDetails}.
Set new parameter values {updateDetails} on dataset {datasetId}.
GET /groups/{groupId}/datasets List datasets in a workspace · Power Bi List Datasets in a Workspace #
Ask an LLM
“Which datasets are in a shared team workspace?”
“Can I list datasets for a workspace other than My Workspace?”
Tell an agent
List the datasets in workspace {groupId}.
Show all datasets inside the {groupId} workspace.

Documentation

📖
Documentation
https://docs.microsoft.com/en-us/rest/api/power-bi/
📖
Authentication
https://docs.microsoft.com/en-us/power-bi/developer/embedded/get-azuread-access-token
📖
GettingStarted
https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedding-content
📖
RateLimits
https://docs.microsoft.com/en-us/power-bi/developer/automation/api-rest-api-limitations
📖
Troubleshooting
https://learn.microsoft.com/en-us/power-bi/developer/embedded/troubleshoot-rest-api

Specifications

⚙
OpenAPI
https://raw.githubusercontent.com/api-evangelist/power-bi/refs/heads/main/openapi/power-bi-datasets-api-openapi.yml

Other Resources

🔗
JSONLD
https://raw.githubusercontent.com/api-evangelist/power-bi/refs/heads/main/json-ld/power-bi-rest-context.jsonld
🔗
SDKs
https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/
🔗
ChangeLog
https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-analytics-power-bi-changelog

Work with this as data

Every API here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for apis

7 MCP tools reach this
  • find_apisBrowse and filter every API in the catalog.
  • get_api_artifactsOne API's artifacts, grouped by type.
  • get_openapiThe primary OpenAPI for this API.
  • find_similar_apisAPIs that look like this one.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This API 
curl "https://apis.io/api/v1/apis/power-bi:power-bi-datasets-api"
All apis 
curl "https://apis.io/api/v1/apis?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.

OpenAPI Specification

power-bi-datasets-api-openapi.yml Raw ↑ 
openapi: 3.2.0
info:
  title: Power BI REST Datasets API
  description: The Power BI REST API provides service endpoints for embedding, administration, governance, and user resources. It enables programmatic access to Power BI content including datasets, reports, dashboards, and workspaces (groups). The API uses Azure Active Directory (OAuth 2.0) for authentication and authorization.
  version: '1.0'
  contact:
    name: Microsoft Power BI Support
    url: https://powerbi.microsoft.com/en-us/support/
  termsOfService: https://powerbi.microsoft.com/en-us/api-terms/
  license:
    name: Microsoft API License
    url: https://powerbi.microsoft.com/en-us/terms-of-service/
servers:
- url: https://api.powerbi.com/v1.0/myorg
  description: Power BI REST API - User context
security:
- bearerAuth: []
tags:


# --- truncated at 32 KB (40 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/power-bi/refs/heads/main/openapi/power-bi-datasets-api-openapi.yml