PowerBI connection with Cassandra Issue

[anandsoftweb]

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.

[v-jiascu-msft]

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