Forum Discussion
Send filtered table as email function on Power BI
Hi all,
I am relatively new on Power BI but I am undertaking a project that is getting a bit complex, and wanted to touch upon the feasibility of sending an email from a filtered table:
- I have a table that takes an application data (e.g.: all the last month input items on a system) and that can be filtered with certain fields (e.g. To which specific domain the input items are, region in which the input is originated...).
- I would like such a table, with the filters applied; to be able to be sent as an email to certain people that can also be selected within the email.
- The flow would then be: I filter as I want -> I click on a button to send the filtered table as an email -> I get prompted to Outlook to send such table to the people interested that I determine on my own on the email itself.
Would it be possible to create such a process using Power BI? I Have been looking for ways like using a Power Automate object; but more than automation I would like to make the filtered table actionable (as I cannot automate such email selection nor the overall table without filters applied).
Your help and guidance on feasibility / components to leverage would be really appreciated!
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!!
4 Replies
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 AIHi 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!!
Hi ATB1999 You can use Power Automate with Power BI to send filtered tables via email. Set up a Power Automate visual in your report to trigger a flow, passing filter parameters. The flow can format the filtered data into a table or attach it as a file and open Outlook for recipient selection.
