cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

Status: Accepted
Comments
Community Support

Hi @Anonymous,

 

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

 

Best Regards,
Qiuyun Yu 

Community Support
Status changed to: Accepted
 
Community Support

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 

Advocate II

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

Regular Visitor

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

New Member

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

New Member

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

Frequent Visitor

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

Regular Visitor

+1 for the same error

Advocate I
Advocate I

Same error. Please update on a fix.