Check dataset refresh status REST API

[jaryszek]

Hi Guys,

i have to check before exporting to PDF if dataset report was refreshed sucessfully.

i have found this method:

GET https://api.powerbi.com/v1.0/myorg/datasets/{datasetId}/refreshes/{refreshId}

but from where i have to know RefreshId (i want to take last refresh status) in order to start exporting report connected to the dataset using API and powershell/java?

So steps:
1) refresh dataset connected to report
2) Refresh report AFTER dataset was completely refreshed

Best,
Jacek

[Mohit_Chhabra]

Check below link to see power bi refresh every second using API. 

https://thetrendsettershub.blogspot.com/2023/08/power-bi-tips-api-refresh.html

[v-mengzhu-msft · Accepted solution]

Hi @jaryszek

You can get the refresh id directly through the relevant API ,it will return refresh id (request id), the relevant statements refer to this document：

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best regards, 

Community Support Team Selina zhu 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly 

[jaryszek]

@v-mengzhu-msft thank you.

It will take last refresh ? How to make this working in the loop in powershell?

Best,
Jacek

[selinaz]

Hi @jaryszek ,

It will take all record of your refresh history.

What do you mean by loops?

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Best regards.

[jaryszek]

@selinaz  thank you i figured this out. The top is taking the last refreshed one and this is working fine 🙂

[jaryszek]

Hi,

Anybody can help?
Best,
Jacek