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