Microsoft

Toggling this to off will prevent Canvas Apps sending data to App Insights, either inside the tenant or outside the tenant.

This feature is an extension to the tabular model. We allow the ability to execute stored procedures, but we do not allow the ability to run arbitrary SQL. This helps provides an additional level of security.

You no longer need to call a Power Automate Flow to use a stored procedure. This feature is in preview and currently in all regions.  This makes development of Power Apps for SQL much easier. And your apps will be faster.  The ability to call stored procedures for the SQL connector directly is an extension to the existing tabular model and gives users access to tables, views, and stored procedures. This feature extends our ongoing support of SQL Server as a primary development target for Power Apps.