Forum Discussion
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
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
4 Replies
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
Thank you. that's exactly what i need. thanks
How you are updating the refresh history in excel file in sharepoint after getting the refresh history through REST API.
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
