Automated export SQL query to Excel and publish on Sharepoint site

RoelV 26 Reputation points
2022-02-07T14:21:32.487+00:00

Hi,

We want to automate report creation. For this we want to submit a query to an Azure SQL database and export the results to an Excel file. This Excel file should be published on an Sharepoint site. To implement this, I looked at Azure Data Factory (no Excel sink), Power Automate (no Azure SQL connector) and Power BI (no report scheduling feature).
As all these products are from Microsoft, I would expect it to be a walk in the park. Any suggestions?

Regards,

Roel

Azure SQL Database
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,680 questions
0 comments
Accepted answer
  1. Ronen Ariely 15,096 Reputation points
    2022-02-07T18:54:24.283+00:00

    Hi,

    There are multiple solutions you can use for the task. According to the tags which you used office-sharepoint-online and azure-sql-database I assume hat the best solution for you will; be using Azure Logic Apps.

    You can schedule the execution using Recurrence trigger, execute query on the Azure Database and get the result using the SQL Server connector and the Execute a SQL query (V2) action, use the SharePoint connector and the Create File action to create csv file

    You can also Create Excel file instead of csv using the the excel connector (check this)

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest