Hello,
I tried to implement the enhanced Dataset refresh as sugessted on this page:
https://docs.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh
Below is the input for the Datafactory web activity of the REST API call:
{ "url": "
https://api.powerbi.com/v1.0/myorg/groups/xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/datasets/xxxxxxxxxxxxxxxx...", "connectVia": { "referenceName": "ir-a2-pub-01", "type": "IntegrationRuntimeReference" }, "method": "POST", "headers": { "Content-Type": "application/x-www-form-urlencoded" }, "body": { "type": "Automatic", "commitMode": "partialBatch", "maxParallelism": 20, "retryCount": 3, "objects": [ { "table": "Fact GL Balance" }, { "table": "Fact GL Movement" } ] }, "authentication": { "type": "MSI", "resource": "
https://analysis.windows.net/powerbi/api" } }
But instead of refresh only the 2 tables I specified here, it refreshes the whole dataset.
Can anyone see what is not working properly here?
Thank you
Hi @Anonymous ,
To perform anenhancedrefresh operation,you must specify one or more parametersin the Request Body. Additional parameters can specify the default or an optional value. When specified, all other parameters are applied to the operation using the default value. If no additional parameters are specified, other parameters won't be applied and a standard refresh operation is performed.
You can refer to the following article to see if it helps. Cancelling Power BI Dataset Refreshes With The Enhanced Refresh API
Best Regards,
Community Support Team _ Caitlyn