get_parameters
Retrieve parameter definitions from a PowerBI dataset including name, data type, current value, required status, and suggested values for use in parameterized queries.
Instructions
Get parameters defined in a PowerBI dataset.
Returns parameter definitions including:
Name and data type
Current value
Whether parameter is required
Suggested values (if defined)
Useful for discovering available parameters before querying parameterized datasets.
Note: Not supported for datasets with SQL, Oracle, Teradata, SAP HANA DirectQuery connections or datasets modified via XMLA endpoint.
Parameters:
dataset_id (required): The dataset ID
workspace_id (optional): Workspace ID. Omit for datasets in "My workspace"
format: Response format - "markdown" or "json" (default: "markdown")
detail: Detail level - "concise" or "detailed" (default: "concise")
Returns: Formatted parameter information with names, types, values, and suggested values.
Example usage:
Get all parameters: dataset_id="abc123"
Get detailed info: dataset_id="abc123", detail="detailed"
Check specific workspace: dataset_id="abc123", workspace_id="workspace456"
Error handling:
If dataset_id not found, verify the ID using get_datasets
"Not supported" errors indicate dataset type limitations
Empty result means no parameters are defined
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset_id | Yes | ||
| workspace_id | No | ||
| format | No | markdown | |
| detail | No | concise |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |