Sharepoint SE cannot connect with Visual Studio 2022
Hello, I am getting this error when I am trying to create a new SharePoint empty project from visual studio I am getting SharePoint connection error. I have checked those steps: 1. Run VS as administrator 2.The user is set as sysadmin of the SQLServer, as well as db_owner of the following DBs. a. WSS_Content b. Sharepoint_Admin_Content c. Sharepoint_Config 3. The user is owner of the SP and has full control. 4. The site is added to the IIS host file. 5. I have cleared VS cache. This also occur when I am trying to import SharePoint Solution File. (.wsp) I am using SharePoint Server Subscription Edition and Visual Studio 2022 Community. Thanks,
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! 🙂
