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 ...
  • ibarrau's avatar
    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.