Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |