cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ehrom Occasional Visitor
Occasional Visitor

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 collection, the following error is encountered: "Expression.Error: Access to the resource is forbidden.".

 

I followed this tutorial: https://docs.microsoft.com/en-us/azure/cosmos-db/powerbi-visualize

 

In previous reports I achieved the connection to the Cosmos DB account and database.

 

I am using the June 2019 version of Power BI Desktop.

10 REPLIES 10
Community Support Team
Community Support Team

Re: Cosmos DB connection issuee

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

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gcedillo Frequent Visitor
Frequent Visitor

Re: Cosmos DB connection issuee

@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):
CosmosCollectionForbidden.png

 

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.

 

 

 

djarvis8 Visitor
Visitor

Re: Cosmos DB connection issuee

Yes, I am having the same problem!

 

Strange thing is that any Cosmos DB created before June or so does NOT have this problem, I can connect and read data just fine.  Any recently created Cosmos DB however incurs this problem.

 

Is there some sort of update to the Cosmos DB connector?  This happens with version 2.72.5556.801 (August 2019).

 

 

yanxind New Member
New Member

Re: Cosmos DB connection issuee

I am using PowerBI Desktop version 2.73.5586.661 64Bit(Sept 2019),  have the same issue when connect CosmosDB data.

Anybody can help?

 

Thanks

 

gcedillo Frequent Visitor
Frequent Visitor

Re: Cosmos DB connection issuee

@yanxind , @djarvis8 :

After contacting MS Support, it seems that MongoDB API configuration for CostmosDB is not currently supported as a PowerBI connector. However, SQL API and Gremlin API configurations are supported.

 

PBIConnector_MS_Support.png

Highlighted
rcyber Regular Visitor
Regular Visitor

Re: Cosmos DB connection issuee

I have got the same issue.

It will be good if MS team answers anything here.

We were working, we have a plans, we advertised very beautiful charts to our customers.

And... What should we do now?

pjohnson Frequent Visitor
Frequent Visitor

Re: Cosmos DB connection issuee

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

rcyber Regular Visitor
Regular Visitor

Re: Cosmos DB connection issuee

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 Frequent Visitor
Frequent Visitor

Re: Cosmos DB connection issuee

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors