CODEWITHSUNDEEP
powerbipowerbi-desktoppowerbi-datasource
Sanjay
Sanjay

Reputation: 301

Is there any REST API to refresh specific table in a Power BI Dataset?

Like a refresh data menu in Power BI desktop.

Like a refresh data menu in Power BI desktop. I have exported these datasets from SQL Server database by running stored procedure query.

Upvotes: 3

Views: 2683

Answers (3)

saso
saso

Reputation: 802

I came across this topic (as I had the same requirement) and it's now possible to refresh a specific table using the Power BI REST API.

Recently the Power BI REST "Refresh" APIs have been updated. Besides doing a full dataset refresh it's now possible to send a more detailed refresh command and to specify a list of tables (or even table partitions) to refresh.

This is done by calling a HTTP POST (instead of GET) method and passing a JSON "refresh definion" in the body.

Example how to refresh a single table:

HTTP POST:

https://api.powerbi.com/v1.0/myorg/groups/[workspace_id]/datasets/[dataset_id]/refreshes

Body:

{
    "type": "Full",    
    "objects": [
        {
            "table": "CostForecast"
        }
    ]
}

More details can be found here: https://learn.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh

When looking at the dataset refresh history in Power BI web interface, such a request is marked as "Via Enhanced API":

Refresh history

Upvotes: 2

GregGalloway
GregGalloway

Reputation: 11625

If your workspace is assigned to a Power BI Premium Capacity or Premium Per User you can use the XMLA endpoint programmatically to refresh just one table in a dataset.

Upvotes: 1

Alex
Alex

Reputation: 115

Unfortunatly not.

The most specific API to refresh data is "Refresh Dataset In Group" but it will update the full dateset. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group

Upvotes: 1

Related Questions