topic Re: How to extract refresh history? in Developer

How to extract refresh history?

H_AS — Tue, 07 Sep 2021 06:19:17 GMT

Hello Everyone,

I want to extract the refresh history of a dataset/data flow.

I tried one of the ways posted on Microsoft that used REST API (I used Postman). I followed the steps from https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history and yet I am getting the following error:

Is there any other method I could use to get the refresh history?

Please help.

Re: How to extract refresh history?

Anonymous — Wed, 08 Sep 2021 08:45:22 GMT

Hi @H_AS ,

If you are a Power BI Admin, you can click the gear icon in the upper right corner of the service page and select the "Admin Portal" option. Find the Refresh summary menu, click on the History tab, and then click on "Export" to download and refresh the history.

Alternatively, you can use Powershell or Rest API to download the refresh history. You can refer to the link below for details.

Note: If you call the relevant Rest API, please make sure you have read or write access to the corresponding dataset or data stream first.

Get refresh history for datasets:

From PowerShell Get Refresh History In Group from Power BI REST APIs and export do CSV

Export-RefreshHistory

Get refresh history for dataflow:

Dataflows - Get Dataflow Transactions

Power BI Dataflow - Refresh History

Best Regards

Re: How to extract refresh history?

bisamuraik — Tue, 16 Aug 2022 21:58:17 GMT

Hi @Anonymous

thank you for the examples. As I see, they use a personal users for login. In my case, I would like to use Application permissions "Tenant.Read.All", but I always get a 401 HTTP response, as "Dataset.Read.All" is required to get datasets refresh tables. Do you have an idea how to solve this with Tenant.Read.All permissions?

Best regards

bisamuraik