Capture Latest Power BI Dataset Refresh via API

[Anonymous]

Hi,

I need to capture the latest Power BI dataset refresh date and time which is refreshed via API through ADF. Please let me know how to do it

@Daniel29195 @amitchandak @lbendlin @Idrissshatila @Ritaf1983 @Ahmedx @aj1973 @PijushRoy 

Regards

Vivek N

[Anonymous]

Thank You for the guidance i will check on these topics 

[NandanHegde]

Hey,

Couple of aspects:

1) In case if you want to capture the log as a part of end procees within the ADf itself,

https://datasharkx.wordpress.com/2022/11/05/refresh-power-bi-dataflow-dataset-from-azure-data-factor...

In this blog, the last web activity within until loop would provide you the latest refresh details like its status , time etc.

2) In case if you want to capture it externally, meaning ADF and this job in silos, you can work as stated by @ibarrau either via Python /Powershell etc by trigerring the REST API

[ibarrau · Accepted solution]

Hi. You can use the Power Bi Rest API for achieving this. You can get the refresh history of specific dataset, make it a dataframe and filter the response by "Via Api" and date.

This is the request you could check: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group

You can also read about libraries like simplepbi for python to make it easier for connecting and getting th result.

I hope that helps,

P/D you can find the category "via api" but you can't know if its from ADF or any other tool running the request.