Send email with attachment of a specific table when alert triggered

[dexter2424]

Hi, 

I haven't found anything useful, so I write here with my question.

I would like to send out an automated email when an alert is triggered. (I have done this with flow and PowerBI alerts), but I wanna show not just the number of exceptions, but a specific table from powerBI where I can see the details of the exceptions. At the moment the email contain only the number of a tile, but I would like to attach a file with the detailed data or a list with the detailed data. 

I have tried many things, but no success. I have Pro users, if it helps

Thank you

[andrescorreaco]

Hi @dexter2424,

Look at this Youtube video by Jason Davidson: "How to EMBED a Power BI Report DATA Directly Into An Alert Driven EMAIL Using Power Automate"
https://youtu.be/tbNvNk11sXM

Best Regards!

[v-luwang-msft]

Hi @dexter2424 ,

 Current power bi not support to do customize on already email.And you could read the article,it tells how to integrate Power BI data alerts with Power Automate.

With it is helpful for you!

Best Regards

Lucien

[dexter2424]

Thanks, but as I mentioned above, I've done with this part, but I don't wanna show only Tile and Threshol values, but whole tables from the report. or an exported attachment from the report. I can do it with a Power Automate button click in the report, but the aim is to avoid button click, and start the flow with data export when an alert triggered. I don't know why it'a not possible and why Power Automate is the name of the app, because it wants manual intervention with button click, so it's Power semi-Automate. 

[lbendlin]

Go to flow.microsoft.com and specify your trigger there.

Philosophical note: there is no such thing as event triggers in Power Automate. Behind the scenes everything is done via polling.

[lbendlin]

Nowadays you do this with a PowerAutomate visual and a flow that runs a XMLA query against your dataset and then formats it into the email body. You can even steal the query from the Power BI visual via the performance analyzer, to make sure the same data is in the email.

[dexter2424]

Thanks for the reply, but I wants to know that how. Because I haven't found any guide what is navigate me through this process one by one.