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 20

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 1,145 Reputation points Microsoft External Staff Moderator

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 1,145 Reputation points Microsoft External Staff Moderator

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 20 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 1,145 Reputation points Microsoft External Staff Moderator

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.
William Macedo Marcondes 20 Reputation points

2025-03-12T12:53:00.0166667+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. 😢
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-13T04:46:57.99+00:00

Hi @William Macedo Marcondes

Has your issue been resolved, or do you need any assistance from my end?
David Seale 0 Reputation points

2025-03-13T15:29:32.3566667+00:00

Hi @William Macedo Marcondes

I believe I have found what we were both looking for.

In the Cosmos DB interface in Azure portal navigate to data explorer, choose home, and the connect feature. Within the connect feature you should see an endpoint and an account key. Use these in Power BI Desktop. Both Cosmos DB connectors work.
William Macedo Marcondes 20 Reputation points

2025-03-13T15:44:09.6833333+00:00

Hello David,

Thank you for your help. As you can see, in my dashboard, there is no "Data Explorer" option or the "Connect" menu.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-18T05:59:48.3933333+00:00

Has your issue been resolved?
William Macedo Marcondes 20 Reputation points

2025-03-18T11:53:35.01+00:00

No Mallaiah. I still have this problem.

4 answers

Your answer

Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

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 1,145 Reputation points Microsoft External Staff Moderator

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 20 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 1,145 Reputation points Microsoft External Staff Moderator

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.
William Macedo Marcondes 20 Reputation points

2025-03-12T12:53:00.0166667+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. 😢
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-13T04:46:57.99+00:00

Hi @William Macedo Marcondes

Has your issue been resolved, or do you need any assistance from my end?
David Seale 0 Reputation points

2025-03-13T15:29:32.3566667+00:00

Hi @William Macedo Marcondes

I believe I have found what we were both looking for.

In the Cosmos DB interface in Azure portal navigate to data explorer, choose home, and the connect feature. Within the connect feature you should see an endpoint and an account key. Use these in Power BI Desktop. Both Cosmos DB connectors work.
William Macedo Marcondes 20 Reputation points

2025-03-13T15:44:09.6833333+00:00

Hello David,

Thank you for your help. As you can see, in my dashboard, there is no "Data Explorer" option or the "Connect" menu.
Mallaiah Sangi 1,145 Reputation points Microsoft External Staff Moderator

2025-03-18T05:59:48.3933333+00:00

Has your issue been resolved?
William Macedo Marcondes 20 Reputation points

2025-03-18T11:53:35.01+00:00

No Mallaiah. I still have this problem.

Answer 1

Hi,

I same issue here. I have the data in Azure Cosmos DB for MongoDB vCore cluster and I want to get that data into Power BI.

I read previous conversation from you guys, and I am wondering why we should go with some kind of workaround solution involving other services, but can't just simply use what we have as an option in Power BI, specifically for MongoDB vCore cluster:

User's image

Why here it is required https:// CosmosDB endpoint, and we all know that one is not available for this type of cluster , connection string that is provided clearly says mongodb+srv:// User's image

So, if I use this kind of formatted connection string , without the port (port is not allowed in this field read it somewhere), then we are getting this error:
User's image

so, on one hand we are forced to use http, https, etc... and on the other hand we can access the MongoDB vCore cluster only from native mongodb driver (pointing out to mongodb+srv:// schema).

So, either we are making some mistake while provisioning the Azure CosmosDB for MongoDB vCore cluster, or Power BI is still not ready to use this kind of connection?

Answer 2

David Seale 0

Hi @Mallaiah Sangi ,

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 20 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 3

PratikLad 1,825 Microsoft External Staff Moderator

Hi @William Macedo Marcondes,

At the moment we can't directly connect the Azure CosmosDB for MongoDB vCore to Power BI.

Currently, this option is only available for API for NoSQL accounts not for MongoDB API.

To work around this, you can create T-SQL views directly in Synapse serverless SQL pools and build BI dashboards for Azure Cosmos DB for MongoDB. See "Use Power BI and serverless Synapse SQL pool to analyze Azure Cosmos DB data with Synapse" for more information

First you need to Set up,Configure and use Azure Synapse Link for Azure Cosmos DB to get the access of the Azure CosmosDB for MongoDB API data in Synapse Serverless SQL database.
Then create the view using Query items with full fidelity schema
You can connect this Model views over containers with Power BI to create your reports.

PratikLad 1,825 Reputation points Microsoft External Staff Moderator

2025-03-24T12:02:50.3533333+00:00

Hi @William Macedo Marcondes,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PratikLad 1,825 Reputation points Microsoft External Staff Moderator

2025-03-25T03:56:32.5366667+00:00

Hi @William Macedo Marcondes,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help

Answer 4

TONY TOMY 0 Microsoft Employee

Hi @Nikolche Karabeleski and @William Macedo Marcondes , you may refer to the article https://learn.microsoft.com/en-us/power-query/connectors/azure-cosmos-db-for-mongodb-vcore for more details about how to connect Power BI to Azure Cosmos DB for MongoDB vCore cluster. Also to answer your question about where to find "Azure Cosmos DB for MongoDB vCore endpoint", you will have to enable the Data API feature in the cluster. Refer to https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/vcore/data-api.Please note that this feature is only available for new clusters. User's image

Copy "Azure Cosmos DB for MongoDB vCore endpoint" from connection string tab once the data API is enabled.

User's image

You can use this endpoint for connecting Power Bi to Azure Cosmos DB for MongoDB vCore cluster.

User's image

Nikolche Karabeleski 5 Reputation points

2025-04-15T08:35:27.4933333+00:00

Hi @TONY TOMY ,

Thanks for your instructions, yes I can confirm that this helped me in my case.
Enabling the Data API feature on the CosmosDB for MongoDB cluster , provided me another API endpoint under the connection strings, so I used that one and get the data into PowerBI directly.

Do you maybe now, are there any kind of limitations using this endpoint, for example limitation in amount of the data that can be retrieved and so on...
Is it good for pulling like huge amount of data?

Thank you in advance,

Br
TONY TOMY 0 Reputation points Microsoft Employee

2025-04-15T12:34:12.23+00:00

Hi @Nikolche Karabeleski , good to know that I was able to address your issue. So far we don't have any limitations like the amount of the data that can be retrieved etc. You can check this article https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/vcore/data-api#limitations. The team will be updating this article if they find any limitations in the future.
Deekshith 0 Reputation points

2025-06-12T10:33:40.7833333+00:00

Hi @TONY TOMY if i am using a old cluster is there a way to enable the data api feature

Share via

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

4 answers

Your answer