Is it possible to automatically generate excel out of pbi Report and mail it as attachment

[Jerinfonterra]

Requirement is to automatically import the pbi report as excel and email as attachement . the report is a table and is a single table . Is there any way using power automate? Using scheduled flows we can only send pdfs it seems. What we are trying to achieve is something similar to export data in powerbi service + email this excel to users in an automated way.. Also please provide any special license requirements for this or if there are any limitations like (rows that can be imported)

[v-mengzhu-msft]

Hi @Jerinfonterra ,

Perhaps a subscription will meet your needs?

If you have Power bi Premuium or Power bi Premium Per User licence, you can create a new subcription:

If you want to import as excel file, you can use paginated report to create a subscription. The following attachment types are supported: PDF, PowerPoint presentation (PPTX), Excel Workbook (XLSX), Word Document (DOCX), CSV file, and XML.

About paginated reports, please refer:

1. Paginated reports in the Power BI service 
2. Subscribe yourself and others to paginated reports in the Power BI service 

Best regards,

Community Support Team Selina zhu