Forum Discussion

Ehrom's avatar
Ehrom
New Member
7 years ago
Solved

Cosmos DB connection issuee

I am trying to connect to a Comos DB (Mongo API) account from Power BI, using the Azure Comos DB (Beta) connector. I can browse the database and list the collections, but when I try to browse a colle...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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.😁

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Ehrom ,

Please check if you have install the latest version of power bi desktop 2.70.5494.761 firstly.

In addition, please clear the permission for the azure cosmos db under data source settings and connect again.

Best Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

EEH & v-piga-msft,

I have the latest PowerBI Version: 2.71.5523.941 64-bit (July 2019).

I have been having this issue recently too (see below):

 

I followed the tutorial as well with the appropriate URI and Primary Key for authentication. Getting the error on step 10.

 

Any guidance would be appreciated.