Table with a lookup column based on a Virtual Entity does not work properly in TDS Endpoint

[rubens-pereira]

Table with a lookup column based on a Virtual Entity does not work in TDS Endpoint

While querying a Dataverse table with a lookup column based on a Virtual Entity using SQL Server Management Studio an error msg was issued. The error msg was “Msg 40000, Level 16, State 1, Line 1 Invalid column name …” and the column was the primary name column of the virtual entity. The virtual entity is being provided by the Sql Virtual Entity Data Provider. The SQL Server Management Studio uses the TDS Endpoint to connect to the Dataverse.

The following print screen illustrates this issue.