Join in direct query mode

[Juuls]

Hi all,

Currently I am trying to join two tables in direct query mode; however, I keep getting the notification that there are no common columns found. I have tried the simple query where I configure a new table with the two tables to join (see screenshot) and I have tried using:

VAR __Table =
NATURALINNERJOIN(
'VW_DWH_Controle',
SELECTCOLUMNS(
'Status_lookup',
"Bron",[Waarde],
"Status",[Run_Status]
)
)

In the screenshot the columns in both tables have the same name; but I also tried with different names and without applying the relationship in the model. Might be relevant to know that status_lookup is a table I have imported manually and vw_dwh_controle is in direct query mode from the database.

Both with the same notion that common columns are lacking. Could someone help me to figure out what I am doing wrong?

Thanks in advance!

Regards,

Juul

[v-stephen-msft · Accepted solution]

Hi @Juuls ,

Sorry for my delayed response.

Please kindly refer to:

https://docs.microsoft.com/en-us/dax/naturalinnerjoin-function-dax#remarks

The NATURALINNERJOIN function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.