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.
66 Comments
v-qiuyu-msftCommunity 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-msftStatus changed:NewtoAccepted
- 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 I am getting this error as well. Is there a fix for this?
I have the same problem! And this update dosent work.
I am still facing the same issue. Please provide an ETA on when this will be fixed.
+1 for the same error
sp8Helper II
Same error. Please update on a fix.
