PBI dataset enhanced refresh via REST API in ADF pipeline: Table refresh

[Anonymous]

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:

Input

{ "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

[po-wei]

Could you try using refresh full?

If partition is ready, automatic type will not get latest data.

Refresh command (TMSL) | Microsoft Docs

Enhanced refresh with Power BI REST API - Power BI | Microsoft Docs

[Anonymous]

Thank you, now it works as expected