This error comes from the SQL Server, which indicates there are no permissions to read this table.
We can try to use an OPENQUERY to work around these limitations.
SELECT * FROM OPENQUERY ('ACUMATICA REST', 'SELECT * FROM [ACUMATICA REST].[CData Acumatica Sys].[Acumatica].[Carrier]');
Also, make sure that the Linked Server -> Permissions -> Security Panel information are corresponding to the credentials used in your SQL Gateway.

