Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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

Submitted by Anonymous on ‎01-14-2019 09:06 AM

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.

Status: Accepted
See more ideas labeled with:
66 Comments (66 New)
Comments
cairesantos
Regular Visitor
‎11-11-2019 10:45 AM

+1 with the same error. Any updates????

Anonymous
Not applicable
‎12-11-2019 08:56 PM

Also experiencing this same issue - took me a while to figure out it was the query table settings! Bit of a flaw really - nothing in the documentation about this...Please can you update this?

 

Thanks

Anonymous
Not applicable
‎01-16-2020 07:04 AM

Same issue here, please fix as soon as possible.

ravikant_9
Frequent Visitor
‎01-21-2020 04:59 AM

Hi,

Still the issue persists. Any update on the solution. 

mdiz
Frequent Visitor
‎01-22-2020 02:33 AM

Just hit this same issue myself. Any update would be appreciated

devenchj
Helper I
Helper I
‎01-28-2020 12:31 AM

I am also facing same issue. Using direct query for the fact table having more than 290+ milliion records whereas other dimension tables which are imported are having just few thousands records. Now I need to create couple of measures with keeping filter from dimension tables. 

 

Please update on fix.

JBDelvaux
Helper I
Helper I
‎04-10-2020 02:27 AM

Let's join the bandwagon. Also hoping for a fix.

vicente-iii
Helper I
Helper I
‎05-11-2020 01:00 AM

I am facing the same issue. I've been using SUMX and LOOKUPVALUE as a workaround. Hope this gets fixed soon

sp8
Helper II
Helper II
‎05-11-2020 01:18 AM
@vicente-iii I have a lot of date and text data, so any kind of sum won't work. But how are you using LOOKUPVALUE to get what you need? Can you please give an example?
Anonymous
Not applicable
‎05-11-2020 06:35 AM

@sp8 I don't know if this will work for you but sharing just in case:

 

https://community.powerbi.com/t5/Desktop/Lookups-when-RELATED-doesn-t-work/m-p/1083795#M501870

Idea Statuses