How to connect Power BI to Azure CosmosDB for MongoDB vCore?

Question

How to connect Power BI to Azure CosmosDB for MongoDB vCore?

William Macedo Marcondes 5

I'm trying to connect Power BI to the Azure CosmosDB for MongoDB vCore Free Tier that I provisioned, but the connector asks for an 'Endpoint,' which is not provided in the resource's general panel. Using MongoCompass with the connection string, the connection works correctly.

Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-10T05:01:00.59+00:00
Hi @William Macedo Marcondes

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As we understand that, you are connecting Power BI to Azure CosmosDB for MongoDB vCore.

To connect Azure Cosmos DB for MongoDB to Power BI, Microsoft provides some options, please go through and let me know if this will suit your needs:

Power BI Connector for Azure Cosmos DB:

You can use the built-in cosmosdb connector in PowerBI Desktop. This option is available in import mode, which means you will be importing data into Power BI. To connect:

Open Power BI Desktop --> Select Get Data > Azure > cosmosdb(beta).

Enter the cosmosDB account endpoint URL and your account key (preferably the read-only key for security).

Once connected, you can navigate through your databases and collections to select and load the data you need.

Direct Query Mode:

If you prefer to work with live data, you can use DirectQuery mode when connecting through Azure Synapse Link. This allows you to create dashboards and reports based on real-time data from your Azure Cosmos DB account without needing to import data into Power BI.

Using Azure Functions:

Although not a direct connection method, you can leverage Azure Functions to create a REST API that interacts with your cosmosdb. This api can then be called from Power BI using the Web connector, allowing you to fetch data dynamically. This approach requires additional setup but can be beneficial for specific use cases where custom data processing is needed.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know
Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-11T01:05:28.16+00:00

Hi @William Macedo Marcondes

Has your issue been resolved, or do you need any assistance from my end?
William Macedo Marcondes 5 Reputation points

2025-03-11T14:42:52.86+00:00

Hello Mallaiah,
Thank you for your help so far.
In this case, it would be much better to use the Power BI Connector, but where can I find the "Cosmos DB account endpoint URL"? The only information I have is the connection string.
Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-12T02:05:47.54+00:00

Hi @William Macedo Marcondes

for Mongo API you can find the same in the connection string under the settings more details please refer to this document

Please let me know if you need more information.

2 answers

Your answer

Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-10T05:01:00.59+00:00

Hi @William Macedo Marcondes

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

As we understand that, you are connecting Power BI to Azure CosmosDB for MongoDB vCore.

To connect Azure Cosmos DB for MongoDB to Power BI, Microsoft provides some options, please go through and let me know if this will suit your needs:

Power BI Connector for Azure Cosmos DB:

You can use the built-in cosmosdb connector in PowerBI Desktop. This option is available in import mode, which means you will be importing data into Power BI. To connect:

Open Power BI Desktop --> Select Get Data > Azure > cosmosdb(beta).

Enter the cosmosDB account endpoint URL and your account key (preferably the read-only key for security).

Once connected, you can navigate through your databases and collections to select and load the data you need.

Direct Query Mode:

If you prefer to work with live data, you can use DirectQuery mode when connecting through Azure Synapse Link. This allows you to create dashboards and reports based on real-time data from your Azure Cosmos DB account without needing to import data into Power BI.

Using Azure Functions:

Although not a direct connection method, you can leverage Azure Functions to create a REST API that interacts with your cosmosdb. This api can then be called from Power BI using the Web connector, allowing you to fetch data dynamically. This approach requires additional setup but can be beneficial for specific use cases where custom data processing is needed.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know
Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-11T01:05:28.16+00:00

Hi @William Macedo Marcondes

Has your issue been resolved, or do you need any assistance from my end?
William Macedo Marcondes 5 Reputation points

2025-03-11T14:42:52.86+00:00

Hello Mallaiah,
Thank you for your help so far.
In this case, it would be much better to use the Power BI Connector, but where can I find the "Cosmos DB account endpoint URL"? The only information I have is the connection string.
Mallaiah Sangi 95 Reputation points Microsoft External Staff

2025-03-12T02:05:47.54+00:00

Hi @William Macedo Marcondes

for Mongo API you can find the same in the connection string under the settings more details please refer to this document

Please let me know if you need more information.

Answer 1

David Seale 0

Hi @Anonymous ,

The screenshot you shared above is for Azure Cosmos DB. For Azure Cosmos DB MongoDB vcore and RU we are not provided with such keys. See example below. The strings do not begin with https:// which is what Power BI expects.

CosmosDB

William Macedo Marcondes 5 Reputation points

2025-03-12T12:51:07.3466667+00:00

Hello everyone.

Thank you for your feedback. Below is a screenshot of the panel available to me in MongoDB vCore.

As you can see, the menus mentioned by you are not displayed. 😢

Answer 2

William Macedo Marcondes 5

Hello everyone.

Thank you for your feedback. Below is a screenshot of the panel available to me in MongoDB vCore.

User's image

As you can see, the menus mentioned by you are not displayed. 😢

Share via

How to connect Power BI to Azure CosmosDB for MongoDB vCore?

2 answers

Your answer