Forum Discussion

nenisat's avatar
nenisat
Frequent Visitor
7 years ago

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 r...
Need Help
nenisat's avatar
nenisat
Frequent Visitor
7 years ago

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.

 

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    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's avatar
    nenisat
    Frequent Visitor
    7 years ago

    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 Connector Advanced Connection Properties

     

    Regards,

    Satish