Known Limitation - SQL Connections

Schema names in SQL connections via the External Data Source, Table Control and SQL connectors default to dbo.

 

Where database schemas are otherwise specified, as shown in the Example below, the fully qualified table name, e.g., HumanResources.Department may be used when connecting to a SQL table using the External Data Source Control, however you can only select the Query option, not the Table option.