Endpoint

Delete a Dataset

Name

delete_dataset

Description

Delete a Dataset by ID. [API reference]

Related Tables

Datasets

Parameters

Parameter

Label

Required

Options

Description

YES

WorkspaceId

Option	Value
Default

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_STR`	`varchar(36)`	36	`False`
Status	`DT_WSTR`	`nvarchar(30)`	30	`False`
HttpStatusCode	`DT_I4`	`int`		`False`

If the column you are looking for is missing, consider customizing Power BI Connector.

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

SSIS API Destination - Access table operation

ODBC application

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

delete_dataset endpoint belongs to Datasets table(s), and can therefore be used via those table(s).

SQL Server

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 [LS_TO_POWER_BI_IN_GATEWAY];

delete_dataset endpoint belongs to Datasets table(s), and can therefore be used via those table(s).