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.
Hi, has this bug been fixed?
Hey, same issue here 🙂
3 years now and still no update???
I have same issue like others, please help. PowerBi Desktop - Version: 2.116.622.0 64-bit (April 2023)
After 4 years **bleep** has not been solved? What is this?
it's kind of ridiculous this still doesn't work... not allowing refresh of directquery datsource to another PBI Dataset. it's insane. why even have that option if you can't refresh?
June 2023 The problem still exisits. Anyone have a work-around?
not an "efficient" way to do things, but you COULD created a calculated table FROM the directquery source, and link that one instead... but yea, not elegant.
I added a support table (duplicated value) in Datavers, then between two DATAVERSE tables RELATED function works. However, this does not solve the problem, but I can measure the units value in my table.
The disadvantage of this solution is I have to upload prices added to the second table. BRSebastian
Four years later and this is still an issue. So is it really a bug or by design?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.