I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display ...

SaveToDB doesn’t support basic database features, and call it a day. It’s feature-packed, where you can execute custom SQL statements directly within Excel.

To the left are three icons. Click Data — the one in the middle — to see the dataset. ... Copy the table and then paste the data into an Excel workbook. How to export data from a Power BI report.