cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nenisat Frequent Visitor
Frequent Visitor

Connecting PowerBI to Azure Cassandra (CosmosDB API)

Hi,

 

I did not find native connectivity from PowerBI to Azure (CosmosDB for) Cassandra API DB.

 

Tried with cdata driver ODBC connection, by supplying https://<contact point> for server, which resulted the error "The connection failed: No cluster is available".   

I am not how to configure ODBC connection and how to get details for server, OLAP etc from Azure portal.

 

Please let me know how to set up ODBC connection for cData / Datastix Cassandra drivers.

 

Also let me know if there is any other way to connect PowerBI to Azure Cassandra.

 

Thanks

4 REPLIES 4
Community Support Team
Community Support Team

Re: Connecting PowerBI to Azure Cassandra (CosmosDB API)

@nenisat ,

 

You can use this custom connector below to connect to Cassandra:

https://www.cdata.com/drivers/cassandra/powerbi/

 

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 Frequent Visitor
Frequent Visitor

Re: Connecting PowerBI to Azure Cassandra (CosmosDB API)

I have already downloaded this driver.

 

Is this for "Apache Cassandra" only  or works for Cassandra on Azure CosmosDB also ?

 

I am looking for a driver to connect PowerBI with "Azure" Cassandra DB (Azure Cosmos DB Cassandra API)

 

 


@v-yuta-msft wrote:

@nenisat ,

 

You can use this custom connector below to connect to Cassandra:

https://www.cdata.com/drivers/cassandra/powerbi/

 

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.


 

Community Support Team
Community Support Team

Re: Connecting PowerBI to Azure Cassandra (CosmosDB API)

@nenisat ,

 

I would suggest you to contact with cdata for more details about this connector.

 

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 Frequent Visitor
Frequent Visitor

Re: Connecting PowerBI to Azure Cassandra (CosmosDB API)

Hi @v-yuta-msft

 

With the help of CData and clearing latency issues from myside, I could able to establish

connection from PowerBI to Azure Cosmos DB for Cassandra.

 

(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 Option.

(3) Also created the same report with Direct Query option.

 

Report created with Import option is working fine and Drill Through option is also working fine

(showing details in the page 2).

 

But the report created with "Direct Query option" is showing the Page1 with Pie Chart, but when

I select Drill Through on Page 1,  on the Page 2 it is keep on waiting (showing circle icon) and no

data is shown. I can say retrieving the data forever. 

 

Also observed without Drill Through option set, both the Pages in the report are retrieving data

without any issues in Direct Query mode.

 

I see problem is here with Drill Through option.

 

Can you please provide us on how to fix this issue. Is there any additional connection properties

I need to pass with the connection. Right now I am leaving the "Advanced Connection Properties"

empty. 

 

Cdata_connection_screen.pngCData Connector Advanced Connection Properties

 

Regards,

Satish 

 

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 152 members 1,544 guests
Please welcome our newest community members: