Forum Discussion
Cosmos db connection in Power BI
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
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.
3 Replies
- Icey
Community Support
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
Microsoft Employee
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
Community Support
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.