Forum Discussion

unknown_anony's avatar
unknown_anony
Helper II
3 years ago

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

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

Need Help

3 Replies

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    You could try

    Test =
SELECTCOLUMNS (
    FILTER ( HRData, HRData[Personnel number] = 'CATS Timesheet Report'[Emp.ID] ),
    "@value", HRData[Eng /Sr Eng]
)
      • johnt75's avatar
        johnt75
        Super User
        3 years ago

        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.