When creating virtual tables using an SQL connection to the Serverless SQL Pool in Azure Synapse, there is a bug related to the primary key.

The table is created in Dataverse and includes a unique GUID and a primary field.

Retrieving multiple records works fine.

There is APIM bug when a specific record is selected.