Export multiple pages into a single excel over email via subscription

[jinalidedhia]

I've a requirement where in we've multiple pages in a report and want to get a export all pages in a single excel with multiple worksheets. And send it into a mail using subscription. Is there a way we can achieve it?

[v-pgoloju]

Hi @jinalidedhia,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Poojara_D12 & @BhavinVyas3003  for prompt and helpful responses.

Just following up to see if the solutions provided  were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[Poojara_D12 · Accepted solution]

Hi @jinalidedhia 

In Power BI, exporting multiple report pages into a single Excel file with each page as a separate worksheet and then emailing it via subscription is not natively supported as a built-in feature. Power BI’s export functionality (via subscriptions or manually) only supports exporting individual pages to PDF or PowerPoint and in some cases, exporting data tables to Excel — but not full multi-page Excel files with structured worksheets.

However, this requirement can be achieved through a workaround using Power Automate in combination with Paginated Reports (if you're using Power BI Premium or Fabric capacity). Paginated Reports support exporting in Excel with each table or dataset mapped to a different worksheet, and you can design the report to reflect each Power BI page as a separate dataset or layout section. Once the Paginated Report is created, you can set up a Power Automate flow that triggers on a schedule or based on data change, exports the Paginated Report to Excel, and then emails it as an attachment to the desired recipients.

If you are restricted to standard Power BI reports, another option is to use Power BI REST API with a script (e.g., in Azure Functions or PowerShell) to programmatically export visuals or tables from each page, write them into an Excel workbook using libraries like xlsxwriter or Excel automation, and then email it via an SMTP or Office 365 connector in Power Automate.

In summary, while native support is limited, with Paginated Reports and Power Automate (and Premium capacity), you can accomplish the requirement effectively. For standard reports, a custom solution involving API or scripting is needed.

[v-pgoloju]

Hi @jinalidedhia 

Just following up to see if the response provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[v-pgoloju]

Hi @jinalidedhia,

Just following up to see if the solutions provided  were helpful in addressing the issue.

If one of the responses helped resolve your query, please consider marking it as the Accepted Solution. Feel free to reach out if you need any further clarification or assistance.

Best regards,
Prasanna Kumar

[v-pgoloju]

Hi @jinalidedhia,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Please refer to the documentation and community discussion below, as they may provide a solution to your issue.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-paginated-integration

https://community.fabric.microsoft.com/t5/Desktop/Exporting-all-the-report-pages-to-Excel-file-forma...

Best regards,
Prasanna Kumar

[jinalidedhia]

Hi, 
Thanks for the response.
is there any blog where its been implemented.

[BhavinVyas3003]

Power BI does not natively support exporting multiple pages to a single Excel file with multiple worksheets via email subscription. Use Paginated Reports + Power Automate (requires Power BI Premium/Fabric) to export to Excel and email it.