Extract power bi datasets refresh history

[Anonymous]

Hi everyone, 

I am would like to extract automatically this table (see picture below) containing all the refresh status details of my datasets, in order to set up a monitoring system. Is there any powershell script that I can use in order to achieve this ? 

Thank you very much !

[GilbertQ · Accepted solution]

Hi @Anonymous 

You can do this using the Power BI REST APIs, from your image you are using Power BI Premium and this is the API you can use

Admin - Get Refreshables For Capacity (Power BI Power BI REST APIs) | Microsoft Docs

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to my research, you can follow this blog to extract the refresh metrics for your entire Power BI workspace using the PowerShell script:

https://data-marc.com/2021/01/07/extract-refresh-metrics-for-your-entire-power-bi-workspace/

You can copy the script from this link:

https://github.com/marclelijveld/Power-BI-Automation/blob/master/PowerBI_RefreshHistoryPerWorkspace.ps1

You have to enter the workspace ID into the script, to get the workspace ID, the easiest way is to copy this part of the URL when you enter a workspace:

How to get WorkspaceId using Power BI Cmdlets for PowerShell

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi @Anonymous 

You can do this using the Power BI REST APIs, from your image you are using Power BI Premium and this is the API you can use

Admin - Get Refreshables For Capacity (Power BI Power BI REST APIs) | Microsoft Docs