Export PowerBI Refresh History

[echodapogi]

Newbie here. 

I am trying to get the Refresh history of my PowerBI dataset and put it into SharePoint List or Excel Sheet. like the below view. 

is there a possible way to do that? 

thanks

[Janni0316]

Hi, I also want to get the refresh history for all our datasets. Thanks to the community I created a query with a refreshable access token to get alle the information about our workspaces, datasets, dataflow.... But now I can't get any further. I would like to use the REST Api to get the Refresh History in Group:

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

(GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes?$top={$top})

I have all the information needed for this URL. But how can I create a query where the {groupId} and the {datasetId} is automatically taken from another table an inserted into the parameters of the URL. So I can get the refresh history from all our datasets in different workspaces without putting the parameters in there manually.

Thanks in advance

[collinq · Accepted solution]

Hi @echodapogi ,

I believe that this is what you are looking for - the api to get refresh history:

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

[echodapogi]

Thank you. that's exactly what i need. thanks

[PRI_IN]

 How you are updating the refresh history in excel file in sharepoint after getting the refresh history through REST API.