topic Re: Refresh Execution Details API status 405 in Developer

Refresh Execution Details API status 405

Anonymous — Fri, 22 Apr 2022 16:33:38 GMT

I am testing the REST call for Refresh Execution Details in PowerBI and getting a 405 Method not Allowed. I understand that this endpoint does not work for scheduled and manual refreshes. But I am trying to do an asynchronous refresh with this API Asynchronous refresh with the Power BI REST API - Power BI | Microsoft Docs (POST /refreshes) using Postman. This refresh shows as refreshType: ViaApi. I try to get this refresh execution details (via Postman) and get the same response and error as the scheduled and manual refreshes.

Am I missing something? Is ViaApi not an Asynchronous refresh?

Thanks!

Re: Refresh Execution Details API status 405

Anonymous — Mon, 25 Apr 2022 09:35:04 GMT

Hi @Anonymous ,

ViaApi indicates refresh was triggered by an API call. I think Get Refresh Execution Rest API returns execution details of an asynchronous refresh operation for the specified dataset from the specified workspace.

For reference:

Datasets - Get Refresh Execution Details

Datasets - Get Refresh Execution Details In Group

Please make sure Asynchronous refresh has completed.

Please make sure the app you use to get token has Dataset.ReadWrite.All or Dataset.Read.All.

HTTP Error “405 Method Not Allowed”: How to solve the problem

Best Regards,
Rico Zhou

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

Re: Refresh Execution Details API status 405

Anonymous — Mon, 25 Apr 2022 13:41:14 GMT

Hi @Anonymous,

what kind of request are you using to get infromations about refresh? I'm using

https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes/{refreshId}

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-execution-details-in-group,

Sometime we get error with this API when there was mistake in JSON body for refresh api.

Re: Refresh Execution Details API status 405

Anonymous — Tue, 03 May 2022 17:08:28 GMT

Hi Marky,

Thanks for the insight!

Yes I am using a service principal with Dataset.ReadWrite.All and Dataset.Read.All permissions. I actually use that one to get the refresh history via the api and works just fine. The problem comes when I use the request you posted here (https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes/{refreshId})

I am still facing this issue

Re: Refresh Execution Details API status 405

Anonymous — Wed, 04 May 2022 13:09:07 GMT

Is the service principal admin for the workspace where dataset is?

Re: Refresh Execution Details API status 405

ljt5 — Fri, 03 Feb 2023 11:40:01 GMT

Hi, this question was never solved.

In my experience, you cannot get the execution details of 'ViaApi' refreshes. Only 'ViaEnhancedApi' refreshes.

I hope this helps, I never found any information about this (I'm not saying there is not information) but in my experience this is what I discovered.