topic Enhanced API - Dataset Refresh - Subscription doesn't send! in Developer

Enhanced API - Dataset Refresh - Subscription doesn't send!

stevedodd — Thu, 08 Sep 2022 09:29:45 GMT

Hi All,

I'm kicking off dataset refreshes using the Enhanced (asynchronous) API.

Enhanced refresh with Power BI REST API - Power BI | Microsoft Docs

URL:

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

Body:

{"type":"Full","commitMode":"transactional","retryCount":1,"applyRefreshPolicy":true,"notifyOption":"NoNotification"}

The dataset successfully refreshes:

And I have a subscription setup to send when dataset is refreshed:

The dataset has not been called by any other process that day - which hopefully rules out the 'Once per day' limitation being the issue.

No subscription email ever sends - but the dataset is definitely updating successfully. We get subscriptions from scheduled refreshes absolutely fine. When amending the body to just {"notifyOption":"NoNotification"} in order to utilise the standard (synchronous) API, the subscription sends successsfully as well!

What am I missing about the enhanced API? Are there any admin settings that need to be enabled? Can't see anything from MSFT documentation or questions around this.

All help appreciated!

Thanks in advance,

Steve

Re: Enhanced API - Dataset Refresh - Subscription doesn't send!

Anonymous — Fri, 09 Sep 2022 09:49:31 GMT

Hi @stevedodd ,

According to the description in the following official documentation, notifyOption is not required and must be excluded from the request body for enhanced refresh.

Datasets - Refresh Dataset In Group

Best Regards

Re: Enhanced API - Dataset Refresh - Subscription doesn't send!

stevedodd — Mon, 12 Sep 2022 08:19:25 GMT

Thank you for your reply - I've tried without the notifyOption parameter but it does not solve the issue unfortunately.

It is a bit puzzling as to why it appears to be listed as a limitation - it doesn't stop the Enhanced refresh from running, so doesn't seem like a limitation at all! I am using a premium capacity (P1).