Filter Columns with Fields Parameter and Export Data to CSV using Power Automate Button

Thanks for the reply from audreygerred , please allow me to provide another insight: 
Hi  HerNameIsWhat ,

First you can try to create a Power Automate visual of the Power BI report, trigger the Power Automate flow through the button, and pass the PBI visual data under the current contextual filtering conditions to Automate to do the creation of the csv table.

Create a Power Automate visual for Power BI - Power BI | Microsoft Learn

Use data operations in Power Automate - Power Automate | Microsoft Learn

After that you can try to use SharePoint action to save the data in SharePoint, and finally use Outlook action to send an email to the user, or you can include the corresponding .csv file in the email attachment.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.