DAX function "RELATED" does not work between DirectQuery and Import tables.

[Anonymous]

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.

[Henrique_Linck]

 Hi, has this bug been fixed?

[Paupaul]

Hey, same issue here 🙂 

[StockTraitor]

3 years now and still no update???

[SebastiaN4K]

Dear MS, 

I have same issue like others, please help. 

PowerBi Desktop - Version: 2.116.622.0 64-bit (April 2023)

[kabanowster]

After 4 years **bleep** has not been solved? What is this?

[tyw214]

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?