Forum Discussion
Cosmos DB connection issuee
Please be kindly noted that the Power BI connector is currently ONLY supported for Azure Cosmos DB SQL API and Gremlin API accounts as per Cosmos DB official doc: Visualize Azure Cosmos DB data by using the Power BI connector
For MongoDB API, it CANNOT be connected with Power BI connecter at this moment. The API check CAN‘T be removed even by creating support ticket. That API check has been coded to disable the interoperability between SQL API and MongoDB API to prevent many known issues mixing up two different APIs.No execption can be made for now.
Encourage you to feedback and vote at PowerBI Ideas and Cosmos DB API for MongoDB User Feedback so the product managers can check and consider to add it.We VALUE your voice as always!!!Thanks.😁
For the record, here is how we fixed the issue:
In Power BI, use the Cosmos DB connector and change your url from https://*.mongo.cosmos.azure.com to https://*.documents.azure.com. This is the URL of the internal CosmosDB without the MongoDB interface on top of it.
Now if you try this, you will get a connection error / authentication error. This is because there is a backend check that makes sure that if you are using on MongoDB API you only connect the the Mongo URL and not direct to the CosmosDB. This API check can be removed by the Microsoft support team. You need to open up a support ticket to get that check removed. After that happened you are able to connect to the underlying CosmosDB data.
It takes some time in Power Query to get anything usefuly out of the internal representation of the data, but hey, at least it works.
Cheers
Thank you for the information, while there are some changes now, please kindly refer to the answer below provided by Jeremy.😀