Oct 14 2021 11:22 AM - edited Oct 14 2021 11:27 AM
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! 🙂
Oct 22 2021 01:44 AM