Please help me on this.
When I am trying to join two Data Sets then the data is automatically move to SPICE instead of Direct Query?
I suppose when you join two direct queries then the result data set can be the direct query type. Otherwise when you want to join direct query data set with SPICE data set(s) or more SPICE data sets then the result data set must be a SPICE import type.
If you have multiple parent datasets in a join, you can choose direct query mode for your child dataset only if all the parents are from the same underlying data source.