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