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, the best solution I've found that is not a dead end so far is uploading the SP data into Azure SQL Database and using a direct query from the power BI report into Azure for the data. Does anyone have a better way to do this? Currently I am stuck writing the C# code to retrieve the data from the SP List and push the data into my Azure SQL DB.. Thanks in advance for any advice or notes! 🙂