Forum Discussion
Create Button for Export Data and Save As
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.
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.
How did you get the link to the Excel file?
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??
