topic Re: Ability to send mail alerts using custom visual in Developer

Ability to send mail alerts using custom visual

satishr — Tue, 09 Jan 2018 07:51:31 GMT

I have a weird requirement where my client wants a bar chart which can send alerts. The bar chart should look like the one in the picture. Based on some conditions (for example red bar crossing the constant line/value) an alert should be triggered and an email should be sent with the values. It should be real-time, means as soon as the condition is met the mail should be sent and not in time frequencies like every 1hr or every day. Possible?

Re: Ability to send mail alerts using custom visual

v-viig — Tue, 09 Jan 2018 09:01:36 GMT

I suppose that is possbile to implement but you must use some 3rd party library to connect to email server.

Please note such feature would work if and only if the report is opened.

As an alternative, you might subscribe any dashboard and get email once the data is changed (documentation).

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Ability to send mail alerts using custom visual

satishr — Tue, 09 Jan 2018 11:30:16 GMT

Thanks for the reply v-viig. I think we have to set the data refresh frequency in subscriptions to once every hour or once a day. Will it be possible to do something which can send an alert for data changes in real-time? Also, if I create a custom visual can I get real-time data changes by just opening the report and not refreshing it again and again?

Re: Ability to send mail alerts using custom visual

v-viig — Wed, 10 Jan 2018 07:27:45 GMT

I'm not sure if it's possbile to get data in real time.

v-chuncz-msft Do you happen to know how we can get data in real time?

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Ability to send mail alerts using custom visual

v-chuncz-msft — Wed, 10 Jan 2018 10:11:14 GMT

satishr,

You may take a glance at Real-time streaming in Power BI.

Re: Ability to send mail alerts using custom visual

jppp — Wed, 10 Jan 2018 19:25:47 GMT

Is it not possible to create the email trigger directly querying the source system?

Maybe using other techniques, like Microsoft Flow (https://flow.microsoft.com/en-us/) or a custom Azure Function app (https://docs.microsoft.com/en-us/azure/azure-functions/functions-create-scheduled-function)?

-JP

Re: Ability to send mail alerts using custom visual

satishr — Thu, 01 Feb 2018 15:10:07 GMT

Thanks for the reply jppp. The client has dropped this idea and trying something else.

Re: Ability to send mail alerts using custom visual

Anonymous — Thu, 18 Apr 2019 05:30:45 GMT

Is it possible to create alert on such chart in Power BI, because as of now I know that only KPIs, cards and gauges can create alert. Please provide link if alerts can be created on bar graph

Re: Ability to send mail alerts using custom visual

Anonymous — Thu, 18 Apr 2019 05:31:24 GMT

Is it possible to create alert on such chart in Power BI, because as of now I know that only KPIs, cards and gauges can create alert. Please provide link if alerts can be created on bar graph?

Re: Ability to send mail alerts using custom visual

v-evelk — Tue, 23 Apr 2019 15:36:38 GMT

Let's try to find an approach that is not related directly with Power BI.

If I had such task I would create an embeded visual and modified it to add specific attributes in some tag for critical values, then I would analyzed DOM by external code to look for my attribute and if it was found, I would do anything then, send an e-mail for instance, because I will not be limited by visual reuirements in that case.

Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com