Forum Discussion
Email functionality in Power BI Reports
We want to have a button on the power bi report page, which upon clicking will generate an email draft which includes the filtered table according to current filter setup.
PBI provides a similar native functionality. But it has some undesired issues, e.g., truncating the table display.
Can we do it using the power automare visual in power bi , if yes then what are the limitaion and licences required in both Power BI/Fabric and Power Automate
Any helpful resource will be appreciated.
Hi Shubham_rai955 ,
If the requirement is to email the full, untruncated table based on the current filter context, a better approach would be to use Power BI Paginated Reports (Report Builder) instead of relying on exporting visuals from an interactive report. Paginated Reports are specifically designed for pixel-perfect, tabular outputs and support exporting complete datasets to formats such as CSV, Excel, or PDF without the row or layout limitations seen in standard Power BI visuals. You can pass filter values as parameters, export the report by attach the resulting file to an email, ensuring all filtered rows are included. This approach is more reliable for operational or data-heavy reporting scenarios and avoids the truncation issues you’re currently encountering.
Please go through the referred article:
Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft LearnExport paginated reports with Power Automate - Power BI | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
8 Replies
You're probably better off using Power Automate and then calling Power BI.
There's quite a robust solution given here: https://community.fabric.microsoft.com/t5/Power-Query/Embedding-graphs-into-Emails-from-Power-Bi-via-Power-Automate/td-p/3205150
JamieHolding , Can we setup the flow in the power automate then tie that flow in the power bi report using the power automate visual?
Yes, that should be fine.
- Flow Limitations:
- Flows triggered from Power BI cannot return data to the report (they’re one-way triggers).
- Use Power BI datasets as a bridge if you need data feedback (e.g., flow updates a dataset → Power BI refreshes).
- Flow Limitations:
JamieHolding Thanks for the response, I was facing a issue when I am sending the table visual it is getting trucated as per the current view, Can we extract the table data in a CSV and add that CSV data as a attachement and table in a email.
Have you faced this requirement earlier? or any other resource I can follow.Hi Shubham_rai955 ,
If the requirement is to email the full, untruncated table based on the current filter context, a better approach would be to use Power BI Paginated Reports (Report Builder) instead of relying on exporting visuals from an interactive report. Paginated Reports are specifically designed for pixel-perfect, tabular outputs and support exporting complete datasets to formats such as CSV, Excel, or PDF without the row or layout limitations seen in standard Power BI visuals. You can pass filter values as parameters, export the report by attach the resulting file to an email, ensuring all filtered rows are included. This approach is more reliable for operational or data-heavy reporting scenarios and avoids the truncation issues you’re currently encountering.
Please go through the referred article:
Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft LearnExport paginated reports with Power Automate - Power BI | Microsoft Learn
I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi Shubham_rai955 ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank you.May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank youHi Shubham,
Try Inforiver Writeback Matrix for exporting reports to mail seamlessly with with custom subject and filters applied for each users.
