Forum Discussion

dk_dk's avatar
dk_dk
Icon for Super User rankSuper User
4 years ago

CosmosDB Account Key stopped working for dataset refresh on PowerBI Service

Hi,   I have made a simple report based on an Azure CosmosDB database. I have an account key which worked in PowerBI desktop to set up the datasource, do the query and publish. The published report...
Need Help
v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
4 years ago

Hi dk_dk,

 

Could you provide some screenshots of your issue?

 

When data refresh failure because of password change or expired credentials, please refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#data-refresh-failure-because-of-password-change-or-expired-credentials

 

 

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

 

dk_dk's avatar
dk_dk
Icon for Super User rankSuper User
4 years ago

Hi v-xulin-mstf ,

 

 

See the screenshots above. When I click edit credentials and enter the Account key for the cosmos db I get the above error, with status code 400.

 

However, I am able to manually refresh the same dataset in powerbi desktop using the same credentials, and then publish the updated report to the powerbi service. I have tried all 4 privacy level settings as a troubleshooting step - same error every time.

 

 

Br,

dk