Forum Discussion
undefined
I am pulling data through odbc connection from vertica where as I am not getting a option for import and direct query ( Data connectivity mode). Is the direct query option available for vertica odbc connection in power bi ?
The Below one is for vertica connection.
This option i am getting while connecting with sql server database.
Are you using the 'ODBC" as your data source? If so that's the problem, ODBC drivers only import as a native function and does not allow direct query. You do not need to change the DSN name or the ODBC configuration from the driver. You either have to
1. Change from ODBC to SQL server / or vertica directly (see screenshot below using the DSN name from the ODBC driver)
or
2. Download an ODBC driver version that has a vertica compatible driver that can use vertica as an option for Power BI data source (Again no need to change the DSN name that you created on ODBC).
If you don't have the vertica driver for ODBC here are the instructions to install.
3 Replies
there is official documentation for directquery supported datasources .
please refer to this :
https://radacad.com/directquery-connection-in-power-bi-how-does-it-work-limitations-and-advantages
Hi Daniel29195 , I got it but the picture from my post you can have a look which i have given it for reference. I am using odbc connection for vertica in which the option of direct query is not available.
is that so ?Are you using the 'ODBC" as your data source? If so that's the problem, ODBC drivers only import as a native function and does not allow direct query. You do not need to change the DSN name or the ODBC configuration from the driver. You either have to
1. Change from ODBC to SQL server / or vertica directly (see screenshot below using the DSN name from the ODBC driver)
or
2. Download an ODBC driver version that has a vertica compatible driver that can use vertica as an option for Power BI data source (Again no need to change the DSN name that you created on ODBC).
If you don't have the vertica driver for ODBC here are the instructions to install.
