Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
KalpanaW
Frequent Visitor

Azure cosmos DB(Beta) connector and Cosmos DB - Table

Hi,

   We have some entities in cosmos db -Table and I am trying out possibility of building some dashboards in PBI desktop using Azure cosmos DB(Beta) connector.  Is this connector supported only for Cosmos Db - Document DB API as of now?  I am unable to connect to cosmos db - Table API endpoint using this. I get following error. Are there any alternate solutions for getting table data in PBI? Thanks!

 

TableAPICosmosDbConnector.PNG

3 REPLIES 3
biggshaad
New Member

I also wasn't able to get it to connect with the infomation given. 
I had to use :

https://[acccountName].documents.azure.com:443/ instead of 

https://[acccountName].table.cosmosdb.azure.com:443/ that was showed in the demo.

v-ljerr-msft
Employee
Employee

Hi @KalpanaW,

 

Could you try using Azure Cosmos DB ODBC driver with Power BI to see if it works? For more details about how to connect to Azure Cosmos DB using BI analytics tools with the ODBC driver, you can refer to this article. Smiley Happy

 

Regards

@v-ljerr-msft Thanks ! I will give a try.

 

-Kalpana

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.