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.
I have reported this issue internally: CRI 100120097. Will update here once I get any information.
Best Regards,Qiuyun Yu
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.
Is this issue resolved?
I am getting the same error when trying to use RELATED between direct query table and import table.
I am getting this error as well. Is there a fix for this?
Would be nice if this could be made possible in an update:)
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
Same error. Please update on a fix.