Question
You attempt to connect Power BI Desktop to a Cassandra database.
From the Get Data connector list, you discover that there is no specific connector for the Cassandra database.
You need to select an alternate data connector that will connect to the database.
Which type of connector should you choose?
- A. Microsoft SQL Server database
- B. ODBC Correct
- C. OLE DB
- D. OData
Explanation
When Power BI has no dedicated connector for a database, the generic ODBC connector can connect to any source that has an ODBC driver installed, and Cassandra ODBC drivers are widely available. The SQL Server connector only works with SQL Server, OData needs an OData web feed, and OLE DB depends on an OLE DB provider, which Cassandra does not commonly offer.
