DAX function "RELATED" does not work between DirectQuery and Import tables.

[Anonymous]

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.

[v-qiuyu-msft]

Hi @Anonymous,

I have reported this issue internally: CRI 100120097. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Anonymous ,

PG team already created a bug item to track this issue. 

PG team will try to add comments or a new article to clarify the related function work in certain scenarios.

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi,

Is this issue resolved? 

I am getting the same error when trying to use RELATED between direct query table and import table.

Regards,

Maddy

[jsteckel]

I am getting this error as well.  Is there a fix for this?

[Anonymous]

Would be nice if this could be made possible in an update:)

[Edu]

I have the same problem! And this update dosent work.

[mshilendhari]

I am still facing the same issue. Please provide an ETA on when this will be fixed.

[corbin-ecm]

+1 for the same error

[sp8]

Same error. Please update on a fix.