https://community.qlik.com/t5/Connectivity-Data-Prep/Not-Getting-quot-Direct-Query-quot-option-for-Microsoft-SQL/m-p/2141094#M13058 <P>Hi <SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/195125">@Bi-Muni_9</a></SPAN>&nbsp;</P> <P>&nbsp;</P> <P>Are you using SQL connection via data gateway? Because the direct query is not supported for data gateway SQL connections. Limitations are listed here:&nbsp;</P> <P>&nbsp;</P> <P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/limitations-direct-query.htm" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/limitations-direct-query.htm</A>&nbsp;</P> <P>&nbsp;</P> Fri, 24 Nov 2023 11:37:57 GMT Vinay_B 2023-11-24T11:37:57Z https://community.qlik.com/t5/Connectivity-Data-Prep/Not-Getting-quot-Direct-Query-quot-option-for-Microsoft-SQL/m-p/2140990#M13057 <P>Hi All,</P> <P>I am not getting "Direct Query" option for my Microsoft SQL database.</P> <P>Any suggestion/help will be appreciated.</P> <P>Thanks in advance!!</P> <P>Best Regards,</P> <P>Muni.</P> Fri, 24 Nov 2023 06:50:48 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Not-Getting-quot-Direct-Query-quot-option-for-Microsoft-SQL/m-p/2140990#M13057 Bi-Muni_9 2023-11-24T06:50:48Z https://community.qlik.com/t5/Connectivity-Data-Prep/Not-Getting-quot-Direct-Query-quot-option-for-Microsoft-SQL/m-p/2141094#M13058 <P>Hi <SPAN style="background: var(--ck-color-mention-background); color: var(--ck-color-mention-text);"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/195125">@Bi-Muni_9</a></SPAN>&nbsp;</P> <P>&nbsp;</P> <P>Are you using SQL connection via data gateway? Because the direct query is not supported for data gateway SQL connections. Limitations are listed here:&nbsp;</P> <P>&nbsp;</P> <P><A href="https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/limitations-direct-query.htm" target="_blank">https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/limitations-direct-query.htm</A>&nbsp;</P> <P>&nbsp;</P> Fri, 24 Nov 2023 11:37:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Not-Getting-quot-Direct-Query-quot-option-for-Microsoft-SQL/m-p/2141094#M13058 Vinay_B 2023-11-24T11:37:57Z