Forum Discussion
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.
Super UserHello! When I have a visual that uses field parameters and export the data, only the data showing in the visual exports. All I do is hover on the visual, select the three dots, select export data and choose whether I want it to be .xlsx or .csv. Only the items I have chosen from the field parameter and the measures that I have in the visual export. It does not include items that the user did not select from the field parameters.
Thanks for the reply, I’m aware of that option but for this requirement, I'm trying to automate the process for getting the data, how it's supposed to work is the user selects the fields and exports the data to a CSV file that is stored on SharePoint and then an email gets sent out to specific users that the data is available for them to use.