When using the DAX function "RELATED" to add a new column from an Imported table to a DirectQuery table, I receive an error. This error does not occur if both tables are using DirectQuery.
Column: SampleColumn = RELATED(ImportTable[Column])
Error: "The column 'ImportTable[Column]' either doesn't exist or doesn't have a relationship to any table available in the current context."
Relationship: DirectQueryTable[SampleKey] (many) has a relationship with ImportTable[SampleKey] (one)
Cardinality = Many to One (*:1)
Cross filter direction = Both
Make this relationship active = Checked
Note: When creating the column using "RELATED" in the DirectQueryTable table, ImportTable shows up as a suggestion.
+1 with the same error. Any updates????
Also experiencing this same issue - took me a while to figure out it was the query table settings! Bit of a flaw really - nothing in the documentation about this...Please can you update this?
Same issue here, please fix as soon as possible.
Still the issue persists. Any update on the solution.
Just hit this same issue myself. Any update would be appreciated
I am also facing same issue. Using direct query for the fact table having more than 290+ milliion records whereas other dimension tables which are imported are having just few thousands records. Now I need to create couple of measures with keeping filter from dimension tables.
Please update on fix.
Let's join the bandwagon. Also hoping for a fix.
I am facing the same issue. I've been using SUMX and LOOKUPVALUE as a workaround. Hope this gets fixed soon
@sp8 I don't know if this will work for you but sharing just in case: