EndPoint Truncate a Push Dataset Table
Name
truncate_push_dataset_table
Description
Reads a Table of a Dataset. [API reference]
Parameters
Parameter | Label | Required | Options | Description | ||||
---|---|---|---|---|---|---|---|---|
TableName | TableName | YES | ||||||
DatasetId | DatasetId | NO | ||||||
WorkspaceId | WorkspaceId | NO |
|
Output Columns
Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
---|---|---|---|---|---|
DatasetId |
DT_STR
|
varchar(36)
|
36 | False |
|
TableName |
DT_WSTR
|
nvarchar(150)
|
150 | 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime. |
Examples
SSIS
Use Power BI Connector in API Source component to read data or in API Destination component to read/write data:
Truncate a Push Dataset Table using API Source
Power BI
Truncate a Push Dataset Table

Truncate a Push Dataset Table using API Destination
Power BI
Truncate a Push Dataset Table

ODBC application
Use these SQL queries in your ODBC application data source:
Tables - Truncate a Push Dataset Table
SELECT *
FROM truncate_push_dataset_table
WITH (TableName='MyTable')
-- More info on truncating a Push Dataset Table:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-delete-rows
Tables - Truncate a Push Dataset Table in a specified Dataset
SELECT *
FROM truncate_push_dataset_table
WITH (DatasetId='aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee', TableName='MyTable')
-- More info on truncating a Push Dataset Table:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-delete-rows
SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Tables - Truncate a Push Dataset Table
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM truncate_push_dataset_table
WITH (TableName=''MyTable'')
-- More info on truncating a Push Dataset Table:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-delete-rows';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_POWER_BI_IN_DATA_GATEWAY];
Tables - Truncate a Push Dataset Table in a specified Dataset
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT *
FROM truncate_push_dataset_table
WITH (DatasetId=''aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee'', TableName=''MyTable'')
-- More info on truncating a Push Dataset Table:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-delete-rows';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_POWER_BI_IN_DATA_GATEWAY];