cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sjc4062 Frequent Visitor
Frequent Visitor

API- Get Last Refresh of all reports of a workspace

I am looking to develop a solution to alert me when any report does not automatically refresh overnight. 

The powerbi rest API seems to be the easiest way to accomplish this

 

I can get a full list of all the reports in my workspace using this: 

Get https://api.powerbi.com/v1.0/myorg/groups/GROUP_ID/datasets

 

which returns something like this:

{
"id": "ID",
"name": "Call Dashboard",
"addRowsAPIEnabled": false,
"configuredBy": "EMAILadress",
"isRefreshable": true,
"isEffectiveIdentityRequired": false,
"isEffectiveIdentityRolesRequired": false,
"isOnPremGatewayRequired": true
},

 

Which gives me a complete list of all the reports but doesnt include the last refresh date

 

Now if i use something like this:

Get https://api.powerbi.com/v1.0/myorg/groups/Group_ID/datasets/DATA_SET_ID/refreshes/?$top=1

 

It gives me:

{
"id": ID,
"refreshType": "Scheduled",
"startTime": "2018-04-18T04:00:31.857Z",
"endTime": "2018-04-18T04:08:49.203Z",
"status": "Completed"
}

 

So basically my question is how can i combine those to return a full list of all reports including the last refresh of each one.

Searched through the google as well as this site but couldn't find any direction 

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft New Contributor
New Contributor

Re: API- Get Last Refresh of all reports of a workspace

A possible workaorund that I could think out is:

Generate an App to use the Power BI Embedded API to get the Reports and the Report refresh details, then create a customer connector under Microsoft Flow, combine the results into an HTML table, after that, send an email with Microsoft Flow to notify the daily changes.

Adding some reference for you:

Register an Azure AD app to embed Power BI content

Custom connector in Microsoft Flow

Run Flow on a Schedule

 

Regards,

Michael

 

1 REPLY 1
v-micsh-msft New Contributor
New Contributor

Re: API- Get Last Refresh of all reports of a workspace

A possible workaorund that I could think out is:

Generate an App to use the Power BI Embedded API to get the Reports and the Report refresh details, then create a customer connector under Microsoft Flow, combine the results into an HTML table, after that, send an email with Microsoft Flow to notify the daily changes.

Adding some reference for you:

Register an Azure AD app to embed Power BI content

Custom connector in Microsoft Flow

Run Flow on a Schedule

 

Regards,

Michael