Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Get refresh history for dataflow:
Dataflows - Get Dataflow Transactions
Power BI Dataflow - Refresh History
Best Regards
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
Get refresh history for dataflow:
Dataflows - Get Dataflow Transactions
Power BI Dataflow - Refresh History
Best Regards
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
24 | |
3 | |
2 | |
2 | |
2 |