Forum Discussion
How to automate daily tasks of executing SQL Store Procedure & save the results to Excel file?
I am new to Power Query and Power BI, I would like to know if there is a way to automate a daily report. My daily task is to send out Excel report with data from 5 SQL Stored Procedures. The curr...
Thank you,
Unfortunately, we don't have Power BI at office right now, I am trying to use Open OpenRowSet() to export to existging Excel file with header template within the SQL Store Procedure, I can schedule this script and another schedule to run the Batch file to copy the updated Excel file to share folder. I am trying this method at this point.