ODBC guide

Refresh a dataset (wait for completion)

Triggers a dataset refresh and waits for it to complete. Set WaitForCompletion='True' in the WITH clause.

SELECT *
FROM refresh_dataset
WHERE Id = 'aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee'
WITH (WaitForCompletion='True')
 
-- More info on refreshing a Dataflow:
-- https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset