Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
Migasuke
Memorable Member
Memorable Member

Refresh single table with Rest API (PowerShell)

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.

 



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi @Migasuke 


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

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @Migasuke 


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

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Thanks. This works!

 



If my answer was helpful please give me a Kudos or even accept as a Solution.

Let's connect on LinkedIn!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

Check out the January 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.