Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Connecting Azure Cosmos DB to Power BI

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.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous

     

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 
      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 ?