Forum Discussion

echodapogi's avatar
echodapogi
New Member
5 years ago
Solved

Export PowerBI Refresh History

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 ...
Dataflow
General Comment
Need Help
Show and Tell
Tutorial Requests
Janni0316's avatar
Janni0316
New Member
5 years ago

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