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.
Issue still persists.Any update?
Same issue still persists here.
Hi MS Team, any updates on when this update will get implemented?
Just checking in, @v-qiuyu-msft and @PBICommunity MS Team...Seems I'm the most recent, of several checking in / adding to the general request for an update regarding this issue. Any info, eta, general progress and/or "bandaid" workarounds (in the meantime) would be a big help.
Is there a workaround while this hasn’t been fixed?
still not working. And the same between directquery and dual
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.