Facing issues with Join between two datasets?

I am unable to join between two datasets. Whenever I am trying to join between two datasets is automatically move to SPICE mode but I need to use Direct Query. How can I do that anyone help me?


Check this tutor, may be it help

You can’t use direct query if your 2 datasets use different data sources.

Thank You both of you for your solutions. Now the issues has been resolved the fault is from my side because at the time datasets creation I selected the SPICE mode instead of Direct Query so at the time of joining when I am trying to join the datasets it moves to the SPICE mode. So I again deleted both of these datasets and create new datasets with Direct Query mode then I got the required results.

Thanks & Regards
Biswajit Dash