topic Re: Web hook for Data Alerts in Developer

Web hook for Data Alerts

adrianrb — Mon, 19 Dec 2016 04:16:15 GMT

Is there a way to get a Power BI Alert to post to a web hook? I know that currently Flows is able to start from a Power BI Alert and made an assumption there was some API that enabled this between products.

Re: Web hook for Data Alerts

Eric_Zhang — Tue, 20 Dec 2016 09:35:27 GMT

adrianrb

I was playing with the PowerBI.GetAlerts() in PowerApps(confirmed with some guys to that it is the same function in the Flow mentioned by you) and found that(in Chrome developer tool(F12)) the function actually sends some request to a URL like
"https://msmanaged-na.azure-apim.net/apim/powerbi/80e44451617f451b987f3779a197c691/metadata/v201606/alerts". It is totally not a familar API like others in Power BI, so I guess that when creating a connection in Power Apps, it may call some internal API to get the alert information and save the information somewhere. Then when calling the GetAlerts, it calls some Power APP REST API.

Let's go back to Power BI, I'm not aware of any documented REST API that can return the alerts. However, based on my test, you can still get the Alerts following below way, I captured the URL and token in Chrome developer tool and got the Alert via POSTMAN. Do note that it looks like a cluster URL and may vary geographically so this approach may not be that reliable. You can submit your idea at Power BI ideas to request a dedicated REST API.

Re: Web hook for Data Alerts

adrianrb — Tue, 20 Dec 2016 22:31:53 GMT

I suppose setting data alerts to call a web hook (any arbitrary URL) is also something that would need to be passed to the ideas forum?

Re: Web hook for Data Alerts

Eric_Zhang — Wed, 21 Dec 2016 01:49:29 GMT

adrianrb wrote:
I suppose setting data alerts to call a web hook (any arbitrary URL) is also something that would need to be passed to the ideas forum?

Yes. You can submit the requirement at the same place.
A workaround I can think of is programmatically reading mail from your mail server and if the alert mail is found, then call the 'web hook".