Prerequisitesīefore following the instructions in this Power BI tutorial, ensure that you have access to the following resources:ĭownload the latest version of Power BI Desktop.ĭownload the sample volcano data from GitHub.Ĭreate an Azure Cosmos database account and import the volcano data by using the Azure Cosmos DB data migration tool. After connecting, you navigate to a collection, extract the data, transform the JSON data into tabular format, and publish a report to Power BI.Ĭreating near real-time Power BI dashboards using Azure Synapse Link is currently supported for Azure Cosmos DB SQL API and Azure Cosmos DB API for MongoDB. This article describes the steps required to connect Azure Cosmos DB account to Power BI Desktop. You can use either DirectQuery or import modes. With Azure Synapse Link, you can connect Power BI to analyze your Azure Cosmos DB data, with no performance or cost impact to your transactional workloads, and no ETL pipelines. After you import Azure Cosmos DB data to Power BI, you can transform it, create reports, and publish the reports to Power BI.Īnother option is to create near real-time reports using Azure Synapse Link for Azure Cosmos DB. You can connect Power BI Desktop to Azure Cosmos DB account with the Azure Cosmos DB connector for Power BI.
Azure Cosmos DB is one of the data source that you can use with Power BI Desktop.
Power BI Desktop is a report authoring tool that enables you to retrieve data from various data sources. Power BI is an online service where you can create and share dashboards and reports.