Unable to connect Cosmos DB using Mongo API to Power BI RRS feed

  • Question

  • When I try to import data from CosmosDB using Mongo API into Power BI, I get the error in the Power BI data source: "Expression.Error: Access to the resource is forbidden."

    Any help to resolve this error would be appreciated.


    • Edited by Kireet1991 Monday, August 19, 2019 6:47 PM
    Monday, August 19, 2019 6:41 PM

All replies

  • Hello Kireet1991

    Connecting to Azure Cosmos DB with the Power BI connector is currently supported for Azure Cosmos DB SQL API and Gremlin API accounts only.

    Tuesday, August 20, 2019 3:12 AM
  • That's just a terrible scenario to be in with something you would expect to be common practice, Microsoft. 
    Wednesday, August 28, 2019 6:34 PM
  • We are sorry we couldn't cater to your needs with this one.

    Request you to submit this feedback on the UserVoice forum for CosmosDB.

    The product team actively listens to feedback and prioritizes features accordingly. You will even be able to track progress and be informed when the feature goes live.

    Monday, September 9, 2019 4:40 AM