ODBC guide

Truncate a table

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

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