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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jaryszek
Post Patron
Post Patron

Check dataset refresh status REST API

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

1 ACCEPTED SOLUTION
v-mengzhu-msft
Community Support
Community Support

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

 

vmengzhumsft_0-1659520033595.png

 

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 

View solution in original post

6 REPLIES 6
Mohit_Chhabra
Regular Visitor

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
Community Support
Community Support

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

 

vmengzhumsft_0-1659520033595.png

 

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 

@v-mengzhu-msft thank you.

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

Best,
Jacek

Hi @jaryszek ,

 

It will take all record of your refresh history.

selinaz_0-1660119728724.png

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.

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

jaryszek
Post Patron
Post Patron

Hi,

Anybody can help?
Best,
Jacek

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.