add_data_source
Create a data source for a Power BI XMLA endpoint in a paginated report (.rdl), supporting legacy SQL or modern PBIDATASET provider formats.
Instructions
Create a new for a Power BI XMLA endpoint. workspace_url accepts a bare workspace name or a full powerbi:// URL. Generates a fresh rd:DataSourceID GUID. Refuses if a DataSource of the same name already exists. provider='sql' (default) emits the legacy DataProvider=SQL + powerbi:// ConnectString + rd:SecurityType shape; provider='pbidataset' emits the modern PBI Desktop shape — DataProvider=PBIDATASET, pbiazure:// ConnectString with ClaimsToken auth, plus rd:PowerBIWorkspaceName / rd:PowerBIDatasetName siblings, no rd:SecurityType.
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": "add_data_source"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | ||
| path | Yes | ||
| provider | No | sql | |
| dataset_name | Yes | ||
| workspace_url | Yes | ||
| integrated_security | No |