Hi @Gimenez, Miguel ,
Welcome to Microsoft Q&A platform and thanks for using Azure services.
As I understand your question about connection between Azure Cosmos DB and Power BI.
You can connect to Azure Cosmos DB from Power BI desktop by using one of these options:
1). Use Azure Synapse Link to build Power BI reports with no performance or cost impact to your transactional workloads, and no ETL pipelines.
You can either use DirectQuery or import mode. With DirectQuery, you can build dashboards/reports using live data from your Azure Cosmos DB accounts, without importing or copying the data into Power BI.
2). Connect Power BI Desktop to Azure Cosmos DB account with the Azure Cosmos DB connector for Power BI. This option is only available in import mode and will consume RUs allocated for your transactional workloads.
Note: Reports created in Power BI Desktop can be published to PowerBI.com. Direct extraction of Azure Cosmos DB data cannot be performed from PowerBI.com.
Reference link: powerbi-visualize
Regarding the ODBC connector, connecting to Azure Cosmos DB with the ODBC driver is currently supported for Azure Cosmos DB for NoSQL only. The current ODBC driver doesn't support aggregate pushdowns and has known issues with some analytics tools. Until a new version is released, you can use one of the following alternatives:
a). Azure Synapse Link is the preferred analytics solution for Azure Cosmos DB. With Azure Synapse Link and Azure Synapse SQL serverless pools, you can use any BI tool to extract near real-time insights from Azure Cosmos DB SQL or API for MongoDB data.
b). For Power BI, you can use the Azure Cosmos DB connector for Power BI.
Reference Link: odbc-driver
Hope this information helps. Let me know you inputs and please reply with your perspective/questions.
- Please don't forget to click on or upvote button whenever the information provided helps you.
Original posters help the community find answers faster by identifying the correct answer. Here is how
- Want a reminder to come back and check responses? Here is how to subscribe to a notification
- If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators