Forum Discussion
Email functionality in Power BI Reports
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
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: