Forum Discussion
NoSql for PowerBI
I'm looking for connect cassandra to Power Bi and i found a way with ODBC connectors. But the problem is that it can't make CQL queries. There is any way to make queries with CQL or a connector?
Hi raulvidal,
The ODBC connector in Power BI Desktop lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver.
You could refer to Connect to data using generic interfaces in Power BI Desktop and Author and Share Power BI Reports on Real-Time Cassandra Data for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
daxCommunity Support
Hi raulvidal,
The ODBC connector in Power BI Desktop lets you import data from any third-party ODBC driver simply by specifying a Data Source Name (DSN) or a connection string. As an option, you can also specify a SQL statement to execute against the ODBC driver.
You could refer to Connect to data using generic interfaces in Power BI Desktop and Author and Share Power BI Reports on Real-Time Cassandra Data for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.