Facing issues with Join between two datasets?

Question & Answer
,
1

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?

2

Hi,

Check this tutor, may be it help

3

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

Cross-source
Cross-source1182×161 17.3 KB

4

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.
image

Thanks & Regards
Biswajit Dash