No Direct query option when join custom sql dataset with another data set

Hi all -

My team member observed a very peculiar issue when trying to 2 data sets ( one data set is a custom sql) and another data set is normal table. Then there is no DIRECT QUERY option and the result data set is going for a SPICE MODE. Is this a feature problem in QuickSight. Please help.

Regards - San

1 Like

HI @Sanjeeb2022 Thanks for raising the issues I have been also facing the same issue when I am trying to join with One Direct Query Datasets with Custom SQL Datasets.

1 Like

I’ll mark it as a feature request.