Ability to send mail alerts using custom visual

[satishr]

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?

[v-chuncz-msft]

@satishr,

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

[jppp]

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

[satishr]

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

[v-viig]

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

[Paruljjw]

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?

[v-evelk]

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

[Paruljjw]

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

[satishr]

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?

[v-viig]

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