Announcements
Is there a way to connect to an Azure SQL table without using a premium connection?
I've seen mixed reports about whether or not connecting to Azure SQL is included with Microsoft O365 E3/5 license.
Unless its an app created prior to the licensing change in October, 2019 there is no way to use Azure SQL that does not require a Premium connector. SQL became a premium connector on October 1, 2019. Users with existing apps where grandfathered in to keep using SQL for 5 years until October 1, 2024. But all new apps using SQL are Premium.
@Pstork1 , thank you for the confirmation!
Are you aware of any "nifty" workarounds to transform SQL tables into a data source that is a standard connection (i.e. Excel)?
I don't know that I would call it nifty. There is no easy way to do it that I am aware of, but you could use SQL Server Integration Services (SSIS) to migrate the data to SharePoint.
Export Data from SQL Server to SharePoint through SSIS (cdata.com)
Thank you!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 427 Most Valuable Professional
11manish 201 Super User 2026 Season 2
MS.Ragavendar 128 Super User 2026 Season 2
