Microsoft Power BI Datasets API

The Datasets API from Microsoft Power BI — 5 operation(s) for datasets.

GitHub OpenAPI
Business capability
Analytics & BI Management BC-610.50

Operations 64

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.
GET /v1.0/myorg/datasets Returns a list of datasets from **My workspace** #
GET /v1.0/myorg/datasets/{datasetId} Returns the specified dataset from **My workspace** #
PATCH /v1.0/myorg/datasets/{datasetId} Updates the properties for the specified dataset from **My workspace** #
DELETE /v1.0/myorg/datasets/{datasetId} Deletes the specified dataset from **My workspace** #
POST /v1.0/myorg/datasets/{datasetId}/executeQueries Executes Data Analysis Expressions (DAX) queries against the provided dataset. #
GET /v1.0/myorg/datasets/{datasetId}/refreshes Returns the refresh history for the specified dataset from **My workspace** #
POST /v1.0/myorg/datasets/{datasetId}/refreshes Triggers a refresh for the specified dataset from **My workspace**. #
GET /v1.0/myorg/datasets/{datasetId}/refreshes/{refreshId} Returns execution details of a refresh operation for the specified dataset from… #
DELETE /v1.0/myorg/datasets/{datasetId}/refreshes/{refreshId} Cancels the specified refresh operation for the specified dataset from **My… #
GET /v1.0/myorg/datasets/{datasetId}/refreshSchedule Returns the refresh schedule for the specified dataset from **My workspace** #
PATCH /v1.0/myorg/datasets/{datasetId}/refreshSchedule Updates the refresh schedule for the specified dataset from **My workspace** #
GET /v1.0/myorg/datasets/{datasetId}/directQueryRefreshSchedule Returns the refresh schedule for a specified DirectQuery or LiveConnection… #
PATCH /v1.0/myorg/datasets/{datasetId}/directQueryRefreshSchedule Updates the refresh schedule for a specified DirectQuery or LiveConnection… #
GET /v1.0/myorg/datasets/{datasetId}/parameters Returns a list of parameters for the specified dataset from **My workspace** #
POST /v1.0/myorg/datasets/{datasetId}/Default.UpdateParameters Updates the parameters values for the specified dataset from **My workspace** #
GET /v1.0/myorg/datasets/{datasetId}/datasources Returns a list of data sources for the specified dataset from **My workspace** #
POST /v1.0/myorg/datasets/{datasetId}/Default.UpdateDatasources Updates the data sources of the specified dataset from **My workspace** #
POST /v1.0/myorg/datasets/{datasetId}/Default.SetAllConnections Updates all connections for the specified dataset from **My workspace**. #
POST /v1.0/myorg/datasets/{datasetId}/Default.BindToGateway Binds the specified dataset from **My workspace** to the specified gateway… #
GET /v1.0/myorg/datasets/{datasetId}/Default.GetBoundGatewayDatasources Returns a list of gateway data sources for the specified dataset from **My… #
GET /v1.0/myorg/datasets/{datasetId}/Default.DiscoverGateways Returns a list of gateways that the specified dataset from **My workspace** can… #
GET /v1.0/myorg/datasets/{datasetId}/queryScaleOut/syncStatus Returns the query scale-out sync status for the specified dataset from **My… #
POST /v1.0/myorg/datasets/{datasetId}/queryScaleOut/sync Triggers a query scale-out sync of read-only replicas for the specified dataset… #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/users Grants the specified user's permissions to the specified dataset #
PUT /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/users Updates the existing dataset permissions of the specified user to the specified… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/users Returns a list of principals that have access to the specified dataset #
POST /v1.0/myorg/datasets/{datasetId}/users Grants the specified user's permissions to the specified dataset #
PUT /v1.0/myorg/datasets/{datasetId}/users Updates the existing dataset permissions of the specified user to the specified… #
GET /v1.0/myorg/datasets/{datasetId}/users Returns a list of principals that have access to the specified dataset #
GET /v1.0/myorg/groups/{groupId}/datasets Returns a list of datasets from the specified workspace #
GET /v1.0/myorg/groups/{groupId}/datasets/upstreamDataflows Returns a list of upstream dataflows for datasets from the specified workspace #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId} Returns the specified dataset from the specified workspace #
PATCH /v1.0/myorg/groups/{groupId}/datasets/{datasetId} Updates the properties for the specified dataset from the specified workspace #
DELETE /v1.0/myorg/groups/{groupId}/datasets/{datasetId} Deletes the specified dataset from the specified workspace #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes Returns the refresh history for the specified dataset from the specified… #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes Triggers a refresh for the specified dataset from the specified workspace. #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes/{refreshId} Returns execution details of a refresh operation for the specified dataset from… #
DELETE /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes/{refreshId} Cancels the specified refresh operation for the specified dataset from the… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshSchedule Returns the refresh schedule for the specified dataset from the specified… #
PATCH /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshSchedule Updates the refresh schedule for the specified dataset from the specified… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/directQueryRefreshSchedule Returns the refresh schedule for a specified DirectQuery or LiveConnection… #
PATCH /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/directQueryRefreshSchedule Updates the refresh schedule for a specified DirectQuery or LiveConnection… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/parameters Returns a list of parameters for the specified dataset from the specified… #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateParameters Updates the parameters values for the specified dataset from the specified… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/datasources Returns a list of data sources for the specified dataset from the specified… #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.UpdateDatasources Updates the data sources of the specified dataset from the specified workspace #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.SetAllConnections Updates all connections for the specified dataset from the specified workspace. #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.BindToGateway Binds the specified dataset from the specified workspace to the specified… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.GetBoundGatewayDatasources Returns a list of gateway data sources for the specified dataset from the… #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.DiscoverGateways Returns a list of gateways that the specified dataset from the specified… #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/Default.TakeOver Transfers ownership over the specified dataset to the current authorized user #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/executeQueries Executes Data Analysis Expressions (DAX) queries against the provided dataset #
GET /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/queryScaleOut/syncStatus Returns the query scale-out sync status for the specified dataset from the… #
POST /v1.0/myorg/groups/{groupId}/datasets/{datasetId}/queryScaleOut/sync Triggers a query scale-out sync of read-only replicas for the specified dataset… #

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:microsoft-power-bi-datasets-api"
All apis
curl "https://apis.io/api/v1/apis?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

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.

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 (221 KB total) ---
# Full source: https://artifacts.apis.io/power-bi/openapi/power-bi-datasets-api-openapi.yml