Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Capture Latest Power BI Dataset Refresh via API

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 ...
Need Help
  • ibarrau's avatar
    ibarrau
    2 years ago

    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.

NandanHegde's avatar
NandanHegde
Super User
2 years ago

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-factory-synapse-pipeline-via-managed-identity/

 

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