Export multiple pages excel and send by email

[feips]

Hi guys

I have a finance report that has 2 pages - summary and details.

Is there are any way to export exporting data of all visuals at once to excel/csv and send it by email? 

i found some videos on the internet by expert the report on pdf but this not serve the purpose of the requirement as the data is finance transaction details, so the business want to receive it by email on excel.

thanks

[Anonymous]

Hi @feips ,
Did rajendraongole1  reply help you, if so. You can mark it as a solution,
If not, you can ask your query below.

Best regards,
Albert He

[rajendraongole1]

Hi @feips - While Power BI doesn't natively support exporting all visuals' data simultaneously to Excel or CSV, leveraging Power Automate with Power BI APIs or direct data source connections provides a robust solution. Alternatively, if you have Power BI Premium, Paginated Reports offer a more streamlined approach for exporting detailed data. By following the methods outlined above, you can automate the export and emailing of your finance transaction details in the desired format.

 you can achieve this using Power Automate (formerly Microsoft Flow) in combination with Power BI APIs or by connecting directly to your data source. Below are detailed methods to accomplish this