Forum Discussion
Solved
Create Button for Export Data and Save As
I would like to create a button in plain sight rather than expect the user to see the "..." to export the data from my visuals. Is there a way to make a button mimic exactly what the "Export data" se...
I was able to do a workaround by creating a button > Action > Web URL. I copied the link to the Excel file (minus any link info after the filename so it doesn't just open the file) and it initiates the Save As dialog.
It's been a while, but I think I just copied it from the Excel file's location in SharePoint. I can't remember if I copied from the opened Excel file's URL or clicking the check circle next to the file and right-clicking and Copy link.
So it sounds like you used a Power Automate to save to sharepoint first - then created the button to the Excel File located? That would make more sense.
Do you or anyone have an example of what this would look like in PBI??