ODBC guide

Truncate a table in a dataset

Removes all rows from a push dataset table in a specific dataset. Supply TableName and DatasetId in the WITH clause.

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