ODBC guide

Refresh a dataflow (wait for completion)

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

SELECT *
FROM refresh_dataflow
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/dataflows/refresh-dataflow