EndPoint Delete a Dataset
Name
delete_dataset
Description
Delete a Dataset by ID. [API reference]
Parameters
Parameter | Label | Required | Options | Description | ||||
---|---|---|---|---|---|---|---|---|
Id | Id | YES | ||||||
WorkspaceId | WorkspaceId | NO |
|
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_STR
|
varchar(36)
|
36 | False |
|
Status |
DT_WSTR
|
nvarchar(30)
|
30 | False |
|
HttpStatusCode |
DT_I4
|
int
|
False |
Input Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
Id |
DT_STR
|
varchar(36)
|
36 | False |
Required columns that you need to supply are bolded.
Examples
SSIS
Use Power BI Connector in API Source component to read data or in API Destination component to read/write data:
Delete rows from Datasets table using API Destination
This EndPoint belongs to Datasets table, therefore you cannot work with it directly. Use this table and table-operation pair instead:
Power BI
Datasets
Delete

ODBC application
This endpoint belongs to the table
Datasets.
You can still use the examples below, but it is advised to work directly with the table.
Use these SQL queries in your ODBC application data source:
Datasets - Delete a Dataset
SELECT *
FROM delete_dataset
WHERE Id = 'aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee'
-- More info on deleting a Dataset:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/delete-dataset
SQL Server
This endpoint belongs to the table
Datasets.
You can still use the examples below, but it is advised to work directly with the table.
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Datasets - Delete a Dataset
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM delete_dataset
WHERE Id = ''aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee''
-- More info on deleting a Dataset:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/delete-dataset';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_POWER_BI_IN_DATA_GATEWAY];