topic Re: Refresh dataset via API issue in Developer

Refresh dataset via API issue

ronant — Tue, 08 Mar 2022 10:49:18 GMT

Hi,

I'm refreshing a dataset via API, however it would sometimes fail. I tried chaning the commitMode to PartialBatch but it's not working.

I'm calling:

https://api.powerbi.com/v1.0/myorg/groups/<my group_id>/datasets/<my dataset_id>/refreshes

with the body:

{
    'notifyOption': 'NoNotification',
    'commitMode': 'partialBatch',
    'retryCount': 1
}

I get the error

{"error":{"code":"InvalidRequest","message":"Dataset ID ... belongs to a shared capacity."}}

What is wrong with the dataset belonging to a shared capacity?

When there's only notifyOption in the body, the refresh starts at least.

By adding more parameters, I'm doing to async refresh (https://docs.microsoft.com/en-us/power-bi/connect-data/asynchronous-refresh) but I don't remember reading anything in the docs mentionning shared capacity and async refresh limitations.

Any ideas why the request is invalid?

Re: Refresh dataset via API issue

Anonymous — Fri, 11 Mar 2022 06:46:49 GMT

Hi @ronant ,

If you are refreshing the dataset that is in a shared capacity, you can only make up to eight requests per day. These eight requests include both scheduled refreshes and API refreshes. You can find more details in the following documentations. Please check whether you hit the following limitation... Any comment or problem, please feel free to let me know.

Refresh dataset REST API Limitations

Data refresh

Best Regards

Re: Refresh dataset via API issue

ronant — Mon, 14 Mar 2022 09:47:29 GMT

The dataset is indeed in a shared capacity however I am not above 8 requests when doing the refreshes.

When testing, this works the first time:

{
    'notifyOption': 'NoNotification',
}

The second with the following doesn't:

{
    'notifyOption': 'NoNotification',
    'commitMode': 'partialBatch',
    'retryCount': 1
}

I tried a third time, same as the first, it also works, no error from the API.

Re: Refresh dataset via API issue

Anonymous — Fri, 20 May 2022 12:34:59 GMT

Hi,

Have you solved this issue?

I am encountering the same thing.

{
'notifyOption': 'MailOnFailure',
'retryCount': 1
}

If I leave the second parameter 'retryCount' as blank then the NotifyOption works. If not, I don't get an email.

Re: Refresh dataset via API issue

gabrielfonseca — Tue, 31 May 2022 18:25:24 GMT

Hi,

I was dealing with this same problem. I think the explanation is in the documentation shared by @Anonymous (maybe it was updated recently, at least I don't remember when I first read the API documentation).

I hope they change this and allow the retry option for shared capacity, as long as it respects the eight requests per day limit.
The retry option was exactly what took us to explore the possibility of using the API to refresh some datasets.

Re: Refresh dataset via API issue

mattio — Mon, 15 Aug 2022 16:04:39 GMT

Could be the inclusion of the 'notifyOption' according to the documentation this should not be included in the web call.

For enhanced refresh, notifyOption is not required and must be excluded from the request body. However, one or more parameters other than notifyOption are required.

Limitations

Re: Refresh dataset via API issue

SDM_1997 — Tue, 16 Aug 2022 13:19:00 GMT

Hi!

In the documentation, it is given that enhanced refresh is not supported for shared capacity. Hence, you are getting the error. Only notifyOption is supported for shared capacity.