Display the refresh information of my reports

[Lainkito59]

Hello, 

I would like to know if it's possible to show in a table all the refresh information of my reports in Power BI ? Below you wil find the table wanted. I would like to have the start date, start time, end time and the duration of the refresh and if possible the status "Completed" if the refresh is ok and "Error" if the refresh didn't succeed.

Thanks in advance for your help !

[tackytechtom · Accepted solution]

Hi  @Lainkito59, 

You can get this kind of information from the Get Refresh History REST API:

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

Here a sample response:

{ "value": [ { "refreshType": "ViaApi", "startTime": "2017-06-13T09:25:43.153Z", "endTime": "2017-06-13T09:31:43.153Z", "status": "Completed", "requestId": "9399bb89-25d1-44f8-8576-136d7e9014b1" } ] }

Here a way on how to connect to Power BI REST API:

https://pbi-guy.com/2023/03/25/connect-with-power-bi-to-the-power-bi-rest-api-with-a-service-princip...

Here an example on how to call the REST API (in this case, the refreshSchedule API):

https://www.tackytech.blog/how-to-get-the-next-scheduled-refresh-date-into-your-power-bi-report/

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[Lainkito59]

Thank you very much @tackytechtom ! It's what I need 😀