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: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

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
karo
Advocate V
Advocate V
‎07-24-2020 04:31 AM

Hi,

It seems that the issue still exists. Any news @?
Regards,
Karo

whQBE
Regular Visitor
‎08-10-2020 12:16 PM

I was able to get around this issue by using direct query on both tables for the last 2 years, then with the July release, all of the sudden, I began getting this issue.

v-yuta-msft
Community Support
Community Support
‎08-24-2020 02:11 AM

@whQBE ,

 

This issue has been fixed currently.

 

Regards,

Jimmy Tao

RidgelineTelco
Regular Visitor
‎08-26-2020 06:00 PM

@v-yuta-msft Issue still exists today when using related() between two direct query tables.

Anonymous
Not applicable
‎09-09-2020 01:51 AM

@v-yuta-msft

 

The issue still persists. Tried DQ to DQ and DQ to Loaded - none works. Please fix this. 

whQBE
Regular Visitor
‎09-09-2020 10:27 AM

With DQ to DQ, I worked around by moving the columns from other queries into the query I was using the RELATED formula on, leveraging the SQL DB I was querying instead of Power BI/DAX. But would still appreciate if this was fixed.

RidgelineTelco
Regular Visitor
‎09-09-2020 02:05 PM

Confirmed with MS support team yesterday that the Related() function still works in July release but is not working in August release. They are escalating to product team for resolution. My work around was uninstalling August and reinstalling July release to restore functionality until permanant fix is available.

Anonymous
Not applicable
‎11-19-2020 08:28 AM

Same issue: in my case it's between a DirectQuery table and Import table.

Anonymous
Not applicable
‎12-14-2020 09:46 PM

Confirm same error, PBI desktop, Version: 2.87.1061.0 64-bit (November 2020)

BenSimond
New Member
‎01-14-2021 01:41 AM

Same error between DQ and Imported tables. Any updates @v-qiuyu-msft ? Many thanks.

Idea Statuses