Set up flow that converts Power BI table to an Excel sheet and send as attached file in email

[Rose__123]

Hi 

I have a Power BI table, which I would like to send in an updated version as an excel file to an email every month. I have only found a way to update an already existing excel file. 

How can I do this?

[mahoneypat · Accepted solution]

The best way to do this is to publish your Power BI report/dataset, set up scheduled refresh, make a simple Paginated Report with the table/data of interest, and then subscribe to that report at the desired frequency.  You can then have a flow that triggers off receipt of that email, and sends a new email with the Excel file attached.

Pat

[Rose__123]

@mahoneypat  thank you for the reply! Is it possible to implement Row Level Security from the Power BI report into the Paginated Report?