cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NoobToPro Frequent Visitor
Frequent Visitor

Azure Cosmos DB Credentials Failing

Hi All,

 

I'm having issues scheduling a refresh a dashboard that is using the Azure Cosmos DB as its data source. The only way I can properly refresh is by re-publishing the dashboard into Power BI service.

 

When I attempt to refresh via Power BI service I get a credential failure:

 

 azure cosmos credential error.png

 

I'm inputting the correct account key, but I'm having no luck. I've already tried deleting the dataset and recreating it. Any idea how to solve this issue? 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Azure Cosmos DB Credentials Failing

Hi NoobToPro,

 

This issue is more related to azure cosmos db side which may caused by your cosmos database key is timeout. You should configure default consistency for an azure cosmos account. 

  1. In the Azure portal, access your Azure Cosmos DB account.
  2. In the account page, click Default consistency.
  3. In the Default Consistency page, select the new consistency level and click Save.

documentdb_change_consistency-1.png 

 

Please refer to this documentation: https://docs.microsoft.com/en-us/azure/cosmos-db/manage-account#keys.

 

Regards,

Jimmy Tao

NoobToPro Frequent Visitor
Frequent Visitor

Re: Azure Cosmos DB Credentials Failing

Thank you. I'll go ahead and let our server team know of this. I'll reply back with any updates. 

Community Support Team
Community Support Team

Re: Azure Cosmos DB Credentials Failing

Hi NoobToPro,

 

Have you solved your issue? Could you kindly mark my answer to finish this thread?


Regards,

Jimmy Tao

NoobToPro Frequent Visitor
Frequent Visitor

Re: Azure Cosmos DB Credentials Failing

No it has not. 

 

@v-yuta-msft, according to this topic on Github the refresh feature on Power BI service doesn't support Cosmos DB. Is this accurate? 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 117 members 1,447 guests
Please welcome our newest community members: