Join in direct query mode

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