Forum Discussion
undefined
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.
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.