Connecting Azure Cosmos DB to Power BI

[durgaraop21]

Currently I am connecting to cosmos db by providing endpoint url in get data menu of power bi desktop application. Endpoint url is taken from azure portal's cosmos db -> key section. Is there any other secure way to connect with out account key?

Can you please anyone tell me how to connect an Azure Cosmos DB to Power BI without account keys.

[v-nuoc-msft · Accepted solution]

Hi @durgaraop21

To your question about securely connecting Azure Cosmos DB to Power BI without using an account key, there is a way to leverage Azure Synapse Link for Azure Cosmos DB without using an account key. Azure Cosmos DB connects to Power BI. Here are the steps to set up a connection using Azure Synapse Link:

Enable Azure Synapse Link for your Azure Cosmos DB account.

Set up Azure Synapse Analytics.

Connect Power BI to Azure Synapse Analytics.

You can view the link below for more details:

Analytics with Azure Synapse Link - Azure Cosmos DB | Microsoft Learn

Power BI tutorial for Azure Cosmos DB | Microsoft Learn

Regards,

Nono Chen

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

[durgaraop21]

@v-nuoc-msft 
Thanks for the solution, Can please tell me
Is there any drawabacks from Azure Synapse , like PBIDS files only support a single data source in one file.
For Example : My sources are one is SQL and other one is Kusto and Azure Cosmos DB, Is it working or not ?