Getting an Invalid Argument Error when i Added a lookup field to my Virtual entity view

[marcusdede-acg]

The trace log confims that query run succesfully against TDS for lookups but crm throws an "invalid argument error".
The filtering by lookup field works perfectly fine, displaying non-lookup fields also ok.

[mikefactorial]

@marcusdede-acg looks like this is a duplicate of #8. Can you turn on Plugin Tracing and see if there's any specific error message in the trace logs that would help pinpoint the issue?

[marcusdede-acg]

@mikefactorial I've checked the traces , i can see the logs regarding the query and returned records .
I also confirm that the query in SQL works perfectly fine.

i've read the following on the microsoft guideline; would that be the reason since i am creating a relationship between dataverse entity-contact- and my virtual table ?

"We recommend that you target a single data source when you use virtual entities in Advanced Finds. For example, creating an Advanced Find that ultimately creates a join between the Dataverse native data and the virtual entity external data isn't supported. "