Hi
I use denodo platform 7.0 in windows. When i connect denodo data view from Power BI i get below error.
--datasource.error: odbc: error [hy000] error while executing the query
Even when i tried to connect from microsoft excel using the option "from microsoft query and ODBC" i get the error "Error loading View".
In the vdp log i get below error.
--- com.denodo.vdb.vdbinterface.server.odbc.ODBCBackend [] - Error: Error loading view
In the vdp-requests log - i found below query
---select n.nspname, c.relname, a.attname ..... from (((pg_catalog.pg_class c inner join pg_catalog.pg_namespace n on ........
Execute above query in VQL shell also give the same error.
Pls give me an idea to solve this.
Regards
Venkat