Azure Cosmos DB Credentials Failing

[Anonymous]

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:

 

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? 

[v-yuta-msft]

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.

 

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

Regards,

Jimmy Tao

[Anonymous]

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

[v-yuta-msft]

Hi NoobToPro,

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

Regards,

Jimmy Tao

[Anonymous]

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?