Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

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
v-qiuyu-msft
Community Support

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
Community Support
Status changed to: Accepted
 
v-qiuyu-msft
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 

Anonymous
Not applicable

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
Regular Visitor

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

Anonymous
Not applicable

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

Edu
New Member

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

mshilendhari
Frequent Visitor

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

corbin-ecm
Regular Visitor

+1 for the same error

sp8
Helper II
Helper II

Same error. Please update on a fix.