Automated reporting to excel spreadsheet

[Vaibhav_k]

Dear Community, I have a stored procedure that runs on a table in database. I run stored procedure daily and copy the content to a spreadsheet and upload the same to sharepoint manually. Is there any way to automate this process? I want to create a new worksheet for each day while a spreadsheet is created monthly. 

[lbendlin]

You can also consider Power Automate Cloud, but be aware that SQL Server is a premium connector.

[pavanmanideep]

Hi,

You can use Power Automate Desktop to Query SQL Db and write to an excel sheet. You may refer the below posts for your reference.

Solved: Export data from sql server to excel sheet in Shar... - Power Platform Community (microsoft....

How to Update an Excel File with Power Automate Desktop » The Analytics Corner (bigmountainanalytics...

If I have answered your question, please mark your post as Solved.

If you like my response or got a direction forward to proceed, please give it a Thumbs Up.

You can accept more than one post as a solution.

Cheers,

PMDY