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, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
thiagobub
New Member

4 years and counting, almost 5.

leebaldwin
Frequent Visitor

So do we think that Microsoft cares enough to fix this problem after it has been an open issue for over 4 years? Many Power BI users will use a DirectQuery / Import and add tables to it, but we cannot use the same DAX functions as if we built it from scratch. It would seem like Microsoft would want to resolve this quickly. 

 

 

greatzto
Frequent Visitor

The issue is still there after so many years. can't believe this

blodus
Advocate III

This problem is OVER 5 YEAR OLD now, @Microsoft . 

 

sCjPjwstVxTpxbZ
Regular Visitor

How does this still not work? Like the another user said. This is OVER 5 YEARS OLD.