power bi paginated reports subscription with excel.

[naga449]

Hi Team,

I have a new requirement, to send mail using subscriptions to users in Excel with multiple sheets with the previous month's data in one sheet and the current month's data in another sheet. we have separate paginated reports for the previous month and the current month. 

could you help me send in one Excel with the current and previous month's data in different sheets in Excel? we can use power automation also.

Thanks and regards,

Naga

[GilbertQ]

Hi @naga449 

As far as I am aware you can only send one subscription per report

With Power Automate you might need to download the data to Sharepoint and then send both files out from Power Automate?