Forum Discussion

H_AS's avatar
H_AS
Regular Visitor
4 years ago
Solved

How to extract refresh history?

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.

 

Need Help
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

    • bisamuraik's avatar
      bisamuraik
      Regular Visitor
      4 years ago

      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