Today getting data out of Business Central Online (SaaS) is too difficult. You can either use API's or OData, which have downsides:

• This is not the prefered language of a data analyst or data engineer
• This does not give access to all tables and columns in Business Central (without writing AL code)

Business Central On-Premises gives direct access to the SQL server 2022. This implies all additional functionality like writing SQL queries, SQL views. This language is more familiar for data analysts and also gives access to every table and column in Business Cetral, including custom tables in Business Central extensions (partner developed or third party apps).

Furthermore Business Central On-Premises runs on SQL servers 2022, thus setting up a Synapse Link is possible. Something currently impossible for the SaaS version of Business Central.

https://learn.microsoft.com/en-us/azure/synapse-analytics/synapse-link/sql-synapse-link-overview

This feels like a huge disadvantage for the SaaS version of Business Central.

Please enable Synapse Link through the assisted setup menu of Business Central SaaS (and On-Premises).

This would solve many issues, this will allow more organizations to switch to the SaaS version of Business Central and it will generate more revenue for Microsoft as it will enable cross selling of Synapse Analytics compute and storage.