Forum Discussion
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 d...
You could try
Test =
SELECTCOLUMNS (
FILTER ( HRData, HRData[Personnel number] = 'CATS Timesheet Report'[Emp.ID] ),
"@value", HRData[Eng /Sr Eng]
)
No it is also giving the same error
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.