set_datasource_connection
Repoint a Power BI Report Builder data source to a XMLA endpoint by specifying workspace URL and dataset name.
Instructions
Repoint a DataSource at a Power BI XMLA endpoint. workspace_url accepts a bare workspace name or a full powerbi:// URL; DataProvider is set to SQL (the AS provider id in RDL).
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"path": "<path>",
"name": "<name>",
"workspace_url": "<workspace_url>",
"dataset_name": "<dataset_name>"
},
"name": "set_datasource_connection"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | RDL DataSource Name attribute. | |
| path | Yes | ||
| dataset_name | Yes | PBI semantic model (Initial Catalog). | |
| workspace_url | Yes | Workspace name or full powerbi:// XMLA URL. | |
| integrated_security | No | Default true. False omits the element. |