Refresh single table with Rest API (PowerShell)

[Migasuke]

Hey Guys,

This topic might be a bit of difficult. I am trying to refresh one specific table in my PBI Service with PowerShell. I am not a professional with PowerShell but I am learning.

I found in documentation, that I need to send JSON where I specify, which table to refresh(I want to refresh table called Sample1). Problem is, whatever I do - I always refresh whole dataset (including the other tables).

Please take a look on my code:

Login-PowerBI
$header = '{
  "refresh": {
    "type": "full",
    "objects": [
      {
        "database": "Refresh Test",
        "table": "Sample1"
      }
    ]
  }
}'

Invoke-PowerBIRestMethod -Url 'https://api.powerbi.com/v1.0/myorg/groups/<myGroupId>/datasets/<myDatasetId>/refreshes' -Method Post -Body($header)

Any help is appreciated. Thanks.

[GilbertQ · Accepted solution]

Hi @Migasuke 

This is the syntax I use below to refersh a single table

{
  "type": "full",
  "commitMode": "transactional",
  "objects": [
    {
      "table": "Sample1"
    }
  ],
  "applyRefreshPolicy": "false"
}

[Migasuke]

Thanks. This works!