See your DBMS chapter for details. The EXECUTE statement cannot be stored as part of an SQL Procedure Pass-Through Facility query in a PROC SQL view. a dynamic non-query, DBMS-specific SQL statement.

To use SQL Server connections in Power Apps ... would you want this procedure to run within a gallery? Probably not. Unless of course you wanted to audit users accessing data.