Forum Discussion

Juuls's avatar
Juuls
Frequent Visitor
5 years ago
Solved

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 confi...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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.