Cosmos db connection in Power BI

[data_insights]

I'm trying to import cosmos data to Power BI. In the past I've used ODBC connector to establish connection and get cosmos data to PBI. Now, I hear that ODBC connector doesn't let you schedule refresh. 

I followed the instructions here but cannot find the "Account key" required in the next steps. How can I get the account key ?

TIA

[Icey]

Hi @data_insights ,

Based on the document, you can retrieve the key from the Primary Key box in the Read-only Keys blade of the Azure portal.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[data_insights]

@Icey Thank you for your repsonse.

I couldnt find a primary key box or the Read-only keys blade in Azure portal. I logged in to the portal but dont see anything about keys. Can you please help me further. Thanks

[Icey · Accepted solution]

Hi @data_insights ,

I find these articles and hope they could help you:

Secure access to data in Azure Cosmos DB,

View, copy, and regenerate access keys.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.