Relate function does not work with the direct query and import mode

[unknown_anony]

Hello ,

I am working on a composite model. Direct query table is my facts table and is connected to the dimesion table by one to many relationship. As checked in the community that relate function does not work with direct query and import mode so instead  i used this below query in a calulated column

Test = LOOKUPVALUE(HRData[Eng /Sr Eng],HRData[Personnel number],'CATS Timesheet Report'[Emp.ID])
but getting and error

Is there any work around for this issue?

Thanks in advance

All suggestions are welcomed

[johnt75]

You could try

Test =
SELECTCOLUMNS (
    FILTER ( HRData, HRData[Personnel number] = 'CATS Timesheet Report'[Emp.ID] ),
    "@value", HRData[Eng /Sr Eng]
)

[unknown_anony]

No it is also giving the same error

[johnt75]

Check the privacy levels for both datasets, and have a look in the options to see if there's anything about sharing data between multiple sources.