undefined

[Anonymous]

Hi,

I'm looking for connect Cassandra to Power Bi. The problem is that i have a database with a lot of data, so i want to filter. When i connect with ODCB the Power Bi can only query with SQL statements so it appear a conflict. I tried to connect with CData Cassandra Direct Query but i also have the same problem because only permits SQL statament and the database is to large .I think about another solution, that consist to extract data from Cassandra database and import to SQL databas but the problem is the same, the two database doesn't understands each other. Any idea of how i can resolve the problem? Thank uo very much

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

There is no direct Cassandra database connector in Power BI currently. 

By my research, you could try with ODBC driver to connect Cassandra database in Power BI.

For the detail steps, please refer to these links" Connect to Cassandra as an ODBC Data Source and Cassandra ODBC driver

Here is a similar solved case you can refer to: https://community.powerbi.com/t5/Desktop/How-to-connect-to-cassandra-from-power-BI/td-p/56462