Forum Discussion
PowerBI connection with Cassandra Issue
Hello Folks,
I am trying to connect the cassandra database with PowerBI using Datastax( Simba Technologies Cassandra ODBC) 3rd part driver but I am getting following error.
Error:
DataSource.Error: ODBC: ERROR [HY000] Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=CData Cassandra Source
OdbcErrors=Table
Can anyone have any idea why this error is coming?
Thanks in Advance.
1 Reply
- v-jiascu-msftMicrosoft Employee
Hi anandsoftweb,
It seems you have created a DSN. It could be the error of Datastax. I would suggest try CData ODBC. Please reference:
1. A post: https://community.powerbi.com/t5/Desktop/How-to-connect-to-cassandra-from-power-BI/td-p/56462
2. A blog: https://www.cdata.com/kb/tech/cassandra-odbc-power-bi.rst
Best Regards!
Dale