Get refresh history with API

[sohvi]

Hi,

I want to make  a report about my other report's refresh history. It will get the data with API and then I will have PowerApps dataflow which will load the data to the report. I have no prior experience with APIs so I need some help.

I'm trying to get the refresh history from workspaces with API but I have issue with the API accesses. I have been using following Youtube video as reference how to do this but I can't give all accesses to the API because of my company's policy.

Does someone know which accesses are needed to get the referesh data with API to a report?

Dataset Refresh Report with Power BI Rest API and Power Automate | Track all your refresh Status 

[rajendraongole1]

Hi @sohvi - using your Azure AD App has the required permissions (Dataset.Read.All or Dataset.ReadWrite.All).
Authenticate using OAuth2 (either user-delegated or service principal authentication).
Use the Power BI REST API to fetch the refresh history.
Optionally, use Power Automate to automate the data flow and store the results for reporting in Power BI or PowerApps.

Since as you're new to APIs, here’s a simplified flow for authenticating and accessing data:

Step 1: Register an Azure AD App: Go to the Azure portal, register an app, and note down the App ID and Client Secret.
Step 2: Assign Permissions: Under API permissions, add Dataset.Read.All or Dataset.ReadWrite.All and grant admin consent for these permissions.
Step 3: Obtain an Access Token: Use the OAuth2 flow to get an access token by passing the App ID, Client Secret, and the appropriate API endpoint.
Step 4: Make API Calls: Use the obtained access token to make the API calls to retrieve the refresh history.

Hope this steps helps.