Forum Discussion
Paginated reports
I have several paginated reports that I would like to send by email using Power Automate, all unified in the same document,like an Excel file with several tabs. Currently I can only send them one by one. There is a way to do this??
Hi, Anonymous
Based on your description, you want to implement a query that uses Power Automate to send multiple paged reports as a unified Excel document. Unfortunately, to date, Power Automate does not inherently support combining multiple paged reports into a single Excel file with multiple tabs in a single step or action.You can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
You may consider using the following method to accomplish your needs.
1. Use Power Automate to create a single step that exports each paged report using the Export to File of Paged Report action.2. Save the exported files to a cloud storage service such as OneDrive or SharePoint.
3. Combine Excel files, either by customizing a script or by using a third-party tool (PowerShell, Python, or VBA) that accesses your cloud storage, downloads the individual Excel files, and combines them into a single Excel workbook, with each report on a separate tab.
4. Email using a combined Excel file: Using a combined Excel workbook, attach the Excel file and email it using the Send Email (V2) action in Power Automate.
Export Paginated reports link: Export paginated reports with Power Automate - Power BI | Microsoft Learn
Send emails: Office 365 Outlook - Connectors | Microsoft Learn
Or you can choose to save the paged report as a PDF file and email it.
Related link: Export and email a report with Power Automate - Power BI | Microsoft Learn
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
1 Reply
Hi, Anonymous
Based on your description, you want to implement a query that uses Power Automate to send multiple paged reports as a unified Excel document. Unfortunately, to date, Power Automate does not inherently support combining multiple paged reports into a single Excel file with multiple tabs in a single step or action.You can submit an idea for here and the product team will take note of such a need.
Related Link: New tab (powerbi.com)
You may consider using the following method to accomplish your needs.
1. Use Power Automate to create a single step that exports each paged report using the Export to File of Paged Report action.2. Save the exported files to a cloud storage service such as OneDrive or SharePoint.
3. Combine Excel files, either by customizing a script or by using a third-party tool (PowerShell, Python, or VBA) that accesses your cloud storage, downloads the individual Excel files, and combines them into a single Excel workbook, with each report on a separate tab.
4. Email using a combined Excel file: Using a combined Excel workbook, attach the Excel file and email it using the Send Email (V2) action in Power Automate.
Export Paginated reports link: Export paginated reports with Power Automate - Power BI | Microsoft Learn
Send emails: Office 365 Outlook - Connectors | Microsoft Learn
Or you can choose to save the paged report as a PDF file and email it.
Related link: Export and email a report with Power Automate - Power BI | Microsoft Learn
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum