Forum Discussion
Send filtered table as email function on Power BI
Hi ATB1999 ,
Thank you for reaching out to Microsoft Fabric Community.
As this is microsoft fabrics forum, i would suggest raising a ticket is power automate forum for faster resolutions.
Forum Link : https://community.powerplatform.com/forums/thread/?partialUrl=MPACommunity
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!
Hi ATB1999 ,
Yep, what you're trying to do is possible — but with a few workarounds since Power BI itself doesn’t support sending filtered visuals directly via email from a button.
Here’s a way to approach it:
- Power Automate visual: You can embed a Power Automate button in your report.
- In the flow, use the Power BI trigger to pass the filtered context (like domain, region, etc.).
- Then use Outlook connector to send an email. You can format the filtered data into an HTML table using Power Automate expressions.
- For recipient selection, you can either:
- Add a text input in the report (via Power Apps visual) and pass that to the flow
- Or prompt the user inside the flow using an approval step (not ideal but doable)
One limitation: Power BI doesn’t allow exporting visuals with filters applied on the fly unless you capture the filter context and rebuild the table in Power Automate.
So yeah, it’s not 100% native, but with Power Automate + a bit of creativity, you can get pretty close to what you want.
Let me know if you want a sample flow or a walkthrough.
If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
translation and formatting supported by AI
Hi burakkaragoz .
Thanks for the response. I have been able to make the filters and the table filter-sensitive through an array transformation of the table (through Initialize Variable). Nonetheless, as I do not have a data for the possible emails we might want to reach, other issues are not possible and we must transfer to the users the choice of the recipients somehow.
I am trying now to trigger an email draft, but I observe that the resulting table is formatted purely as HTML code. Do you have any advice on how could I solve that issue? Below I attached pictures of the flow and the resulting draft.
Hi ATB1999 ,
Thank you for reaching out to Microsoft Fabric Community.
As this is microsoft fabrics forum, i would suggest raising a ticket is power automate forum for faster resolutions.
Forum Link : https://community.powerplatform.com/forums/thread/?partialUrl=MPACommunity
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you!!