Is there a way to connect to an Azure SQL table without using a premium connection?

[cmsteiner3]

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.

[Pstork1 · Accepted solution]

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.

[cmsteiner3]

@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)?

[Pstork1]

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) 

[cmsteiner3]

Thank you!