Send filtered table as email function on Power BI

[ATB1999]

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!

[Akash_Varuna]

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.

[burakkaragoz]

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:

1. Power Automate visual: You can embed a Power Automate button in your report.
2. In the flow, use the Power BI trigger to pass the filtered context (like domain, region, etc.).
3. Then use Outlook connector to send an email. You can format the filtered data into an HTML table using Power Automate expressions.
4. 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

[ATB1999]

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.

[v-sathmakuri · Accepted solution]

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!!