Today the end user can export data from a visual by clicking on the elipse and selecting Export data. I would love to be able to add a button that would do the same thing. Can you create a button to Export Data? Letting the user do it on the spot would be better than using a Power Automate flow. A flow that exports to Excel uses Apply to Each which is slow. I created a flow that exports the data to a CSV file in SharePoint but Power Automate doesn't offer an action to open a SharePoint file. In PowerBI I added a separate button to open the URL of the folder (Action->Type: Web URL). Opening the CSV file's URL causes it to be downloaded. I don't want to train end users to find the downloaded file so I open the parent folder instead.
... View more