The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
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!
Solved! Go to 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!!
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.
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:
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!!