Azure Cosmos DB
An Azure NoSQL database service for app development.
1,786 questions
How to connect Power BI to Azure CosmosDB for MongoDB vCore?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 30%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWM%3C/text%3E%3C/svg%3E)
William Macedo Marcondes
0
Reputation points
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.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Mallaiah Sangi 95 Reputation points Microsoft External Staff2025-03-10T05:01:00.59+00:00 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 Has your issue been resolved, or do you need any assistance from my end?
-
William Macedo Marcondes 0 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 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.
Sign in to comment
Sign in to answer