Forum Discussion
Ability to send mail alerts using custom visual
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?
9 Replies
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
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?
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
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
[email protected]
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
