Connecting PowerBI to Azure Cassandra (CosmosDB API)

Question

Hi,&nbsp;I did not find native connectivity from PowerBI to Azure (CosmosDB for) Cassandra API DB.&nbsp;Tried with cdata driver ODBC connection, by supplying&nbsp;https://&lt;contact point&gt; for server, which resulted the error "The connection failed: No cluster is available".&nbsp; &nbsp;I am not&nbsp;how to configure ODBC connection and how to get details for server, OLAP etc from Azure portal.&nbsp;Please let me know how to set up ODBC connection for cData / Datastix Cassandra drivers.&nbsp;Also let me know if there is any other way to connect PowerBI to Azure Cassandra.&nbsp;Thanks

v-yuta-msft · Answer

nenisat&nbsp;,
&nbsp;
You can use this custom connector below to connect to Cassandra:
https://www.cdata.com/drivers/cassandra/powerbi/
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nenisat · Answer

I have already downloaded this driver.&nbsp;Is this for "Apache Cassandra" only&nbsp; or works for Cassandra on Azure CosmosDB also ?&nbsp;I am looking for a driver to connect PowerBI with "Azure" Cassandra DB (Azure Cosmos DB Cassandra API)&nbsp;&nbsp;v-yuta-msft&nbsp;wrote:nenisat&nbsp;,&nbsp;You can use this custom connector below to connect to Cassandra:https://www.cdata.com/drivers/cassandra/powerbi/&nbsp;Community Support Team _ Jimmy TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.&nbsp;

v-yuta-msft · Answer

nenisat&nbsp;,
&nbsp;
I would suggest you to contact with cdata for more details about this connector.
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nenisat · Answer

Hi&nbsp;@v-yuta-msft&nbsp;With the help of CData and clearing latency issues from myside, I could able to establish connection from&nbsp;PowerBI to Azure Cosmos DB for Cassandra.&nbsp;(1) Created a test table with 3 records in the Cassandra database.(2) Created a simple report with Import option having two pages.Page1 contains a Pie Chart and Page 2 shows the details thru Drill Thourgh&nbsp;Option.(3) Also created the same report with Direct Query&nbsp;option.&nbsp;Report created with Import option is working fine and Drill Through option is also working fine(showing details in the page 2).&nbsp;But the report created with "Direct Query option" is showing the Page1 with Pie Chart, but whenI select Drill Through on Page 1,&nbsp; on the Page 2 it is keep on waiting (showing circle icon) and nodata is shown. I can say&nbsp;retrieving the data forever.&nbsp;&nbsp;Also observed without&nbsp;Drill Through option set, both the Pages in the report are retrieving datawithout&nbsp;any issues in Direct Query mode.&nbsp;I see problem is here with Drill Through option.&nbsp;Can you please provide us on how to fix this issue. Is there any additional connection propertiesI need to pass with the connection. Right now I am leaving the "Advanced Connection Properties"empty.&nbsp;&nbsp;CData Connector Advanced Connection Properties&nbsp;Regards,Satish&nbsp;&nbsp;

Forum Discussion

Connecting PowerBI to Azure Cassandra (CosmosDB API)

4 Replies

Related content

CosmosDB Vs Azure AI Search

Connect to MongoAPI of Cosmosdb

How to connect to cassandra from power BI

Connection failed using a Folder connection in a pipeline

connection to dataflows