get_datasets
Retrieve a list of datasets from a specified PowerBI workspace or My workspace. Use to find dataset IDs, explore available data sources, and check refresh configurations.
Instructions
Get list of datasets from a specific workspace or My workspace.
Datasets in PowerBI contain the data model, including tables, columns, relationships, and measures. This tool retrieves all datasets accessible in the specified workspace.
Use this when you need to:
List all datasets in a workspace
Find a dataset ID for querying
Discover available data sources
Check dataset refresh status and configuration
Parameters:
workspace_id (optional): Workspace (group) ID. If not provided, returns datasets from "My workspace"
format: Response format - "json" or "markdown" (default: "markdown")
detail: Detail level - "concise" or "detailed" (default: "concise")
Returns: List of datasets with their IDs, names, and optionally detailed metadata including refresh status, storage mode, and configuration details.
Example usage:
Get datasets from specific workspace: workspace_id="abc123..."
Get datasets from My workspace: (omit workspace_id)
Get detailed info: detail="detailed"
Error handling:
If workspace_id not found, verify the ID is correct using get_workspaces
For permission errors, ensure service principal has read access to the workspace
Empty list means no datasets in the workspace or no access
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| workspace_id | No | ||
| format | No | markdown | |
| detail | No | concise |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |