Forum Discussion
Extract SharePoint List via Visual Studio Function App and push data into Azure SQL Database
My goal is to embed a PowerBI report into a SharePoint Site looking at data in that SharePoint. I want this data to be live. Dashboard is built out, just needs real time data. Via research...
Hello,
I haven't done it myself, but as an alternative to your C# solution for extracting data from a SharePoint List and loading into your Azure SQL DB, would the Power Platform connector for SQL Server be of any use - https://docs.microsoft.com/en-us/connectors/sql/
Using the connector I think you will be able to have two Power Automate flows, one triggered when adding a new item to your SP List, the second triggered when updating an item in the list.
The Power Automate flows would then use the connector to insert or update records in Azure SQL as needed.
I haven't done it myself, but as an alternative to your C# solution for extracting data from a SharePoint List and loading into your Azure SQL DB, would the Power Platform connector for SQL Server be of any use - https://docs.microsoft.com/en-us/connectors/sql/
Using the connector I think you will be able to have two Power Automate flows, one triggered when adding a new item to your SP List, the second triggered when updating an item in the list.
The Power Automate flows would then use the connector to insert or update records in Azure SQL as needed.
