Trigger PowerBI Dataset via webhook activity

Question

Hi All,

Is it possible to trigger PowerBI Dataset refresh via WebHook activity rather than normal Web Activity.

We are thinking of using WebHook activity as we need to get the status of Dataset refresh from the same activity which is not possible using normal Web Activity.

Answer 1

Hi @Priya Jha ,

Thank you for posting query in Microsoft Q&A Platform.

Webhook activity passes additional property callBackUri in the body sent to the URL endpoint. And then Webhook activity expects this URI to be invoked before the specified timeout value. Click here to know more about webhook activity.

From above statement its clear that the Endpoint should have a logic implemented to invoke webhook activity callBackUrl.

In your case end point is PowerBI dataset refresh API, So we cannot directly control logic inside that API to invoke callBackUrl. Hence you cannot use webhook activity in this case.

We should consider using web activities only to initiate refresh and also to check status of PBI dataset.

You can also consider using Logic apps or writing your own code in Azure Functions too. But I feel using web activities will be easy and best option.

Hope this helps. Please let me know if any further queries.

--------------

Please consider hitting Accept Answer button. Accepted answers helps community as well.