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

pjohnson's avatar
pjohnson
Frequent Visitor
6 years ago

Has anyone heard an update on this issue? We think we are seeing the same issue.

  • rcyber's avatar
    rcyber
    Resolver I
    6 years ago

    Hi pjohnson ,

     

    We have contacted MS and they answered this opprtunity was working accidentaly.

    Finally, we resolved our problem by the following way.

    We have set up daily export the Cosmos database into blob storage on Azure.

    Then we could get a data from it via Power BI.

    I hope it helps you.

    • pjohnson's avatar
      pjohnson
      Frequent Visitor
      6 years ago

      Thanks for that idea! I was able to export the data out to azure storage and work with it from there.

       

      Still would be nice if the native connector inside of Power BI actually worked though...