{"id":4834,"date":"2022-09-08T06:00:55","date_gmt":"2022-09-08T13:00:55","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=4834"},"modified":"2022-09-06T07:57:03","modified_gmt":"2022-09-06T14:57:03","slug":"load-and-visualize-covid-19-case-data-with-the-integrated-power-bi-experience","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/load-and-visualize-covid-19-case-data-with-the-integrated-power-bi-experience\/","title":{"rendered":"Load and visualize Covid-19 case data with the integrated Power BI experience"},"content":{"rendered":"<p>How have major cities like London and New York been affected by Covid-19 and how can we use historical data to explore how these effects might impact us in a post-Covid world?\u00a0 This was the question posed at a Microsoft Data + AI Hackathon held in partnership with the <a href=\"https:\/\/www.ox.ac.uk\/\">University of Oxford<\/a> and <a href=\"https:\/\/observablehq.com\/\">Observable HQ<\/a> at the <a href=\"https:\/\/www.meetup.com\/Microsoft-Reactor-New-York\/\">New York City Reactor Meetup space<\/a> this July.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon.jpg\"><img decoding=\"async\" class=\"alignnone wp-image-4835 size-large\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon-1024x768.jpg\" alt=\"NYC Data Hackathon\" width=\"640\" height=\"480\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon-1024x768.jpg 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon-300x225.jpg 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon-768x576.jpg 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon.jpg 1430w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>Attendees were encouraged to develop new insights based on the following criteria:<\/p>\n<ul>\n<li>Is data retrieved from an Azure data storage service? (<a href=\"https:\/\/azure.microsoft.com\/free\/cosmos-db?WT.mc_id=data-74141-pdecarlo\">Azure Cosmos DB<\/a>, <a href=\"https:\/\/azure.microsoft.com\/free\/storage?WT.mc_id=data-74141-pdecarlo\">Azure Storage<\/a>)<\/li>\n<li>Is data processed using an Azure data analysis service? (<a href=\"https:\/\/azure.microsoft.com\/services\/data-factory?WT.mc_id=data-74141-pdecarlo\">Azure Data Factory<\/a>, <a href=\"https:\/\/azure.microsoft.com\/services\/synapse-analytics\/?WT.mc_id=data-74141-pdecarlo\">Azure Synapse<\/a>)<\/li>\n<li>Is data visualized using an Azure data visualization service? (<a href=\"https:\/\/powerbi.microsoft.com\/?WT.mc_id=data-74141-pdecarlo\">Power BI<\/a>)<\/li>\n<\/ul>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon2.jpg\"><img decoding=\"async\" class=\"alignnone wp-image-4836\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon2.jpg\" alt=\"NYC Data Hackathon team \" width=\"640\" height=\"480\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon2.jpg 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/hackathon2-300x225.jpg 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/p>\n<p>These guidelines provided an opportunity to work with <a href=\"https:\/\/www.microsoft.com\/insidetrack\/data-and-ai?WT.mc_id=data-74141-pdecarlo\">Microsoft data and AI services<\/a> to develop strategies that involve using a combination of cloud services to ultimately tackle the problem statement.\u00a0 There are certainly multiple ways to achieve this, but we had a particular interest in looking at solutions involving Azure Cosmos DB.\u00a0 Specifically for the ability of Azure Cosmos DB to <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/migrate-cosmosdb-data?WT.mc_id=data-74141-pdecarlo\">scale to handle billions of data points<\/a>, ability to <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/choose-api?WT.mc_id=data-74141-pdecarlo\">integrate with existing database APIs<\/a> (MongoDB, Cassandra, and Gremlin), <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/distribute-data-globally?WT.mc_id=data-74141-pdecarlo\">geo-replication capabilities<\/a>, and <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/mongodb\/integrations-overview?WT.mc_id=data-74141-pdecarlo\">integrations with other Microsoft services<\/a> (Power BI being of particular interest).<\/p>\n<p>The remainder of this article will look at how were able to load Covid-19 case count data for New York City into <a href=\"https:\/\/azure.microsoft.com\/free\/cosmos-db?WT.mc_id=data-74141-pdecarlo\">Azure Cosmos DB<\/a> from <a href=\"https:\/\/azure.microsoft.com\/free\/storage?WT.mc_id=data-74141-pdecarlo\">Azure Blob Storage<\/a> using <a href=\"https:\/\/azure.microsoft.com\/services\/data-factory?WT.mc_id=data-74141-pdecarlo\">Azure Data Factory<\/a>, then visualize that data using the <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/integrated-power-bi-synapse-link?WT.mc_id=data-74141-pdecarlo\">Integrated Power BI Experience<\/a> enabled by the <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/synapse-link?WT.mc_id=data-74141-pdecarlo\">Azure Synapse Link for Azure Cosmos DB<\/a>.<\/p>\n<p><strong>Load CSV formatted Covid Case Count data into Azure Cosmos DB with Azure Blob Storage and Azure Data Factory<\/strong><\/p>\n<p>To begin, we will obtain the dataset of interest.\u00a0 For the hackathon, we used the <a href=\"https:\/\/catalog.data.gov\/dataset\/covid-19-daily-counts-of-cases-hospitalizations-and-deaths\">COVID-19 Daily Counts of Cases, Hospitalizations, and Deaths<\/a> CSV available in the United States Government open data store.\u00a0 Additional datasets for other locales in the United States and worldwide can be obtained from sites like the <a href=\"https:\/\/covid.cdc.gov\/covid-data-tracker\">Center for Disease Control and Prevention Data Tracker<\/a> and the <a href=\"https:\/\/covid19.who.int\/data\">World Health Organization<\/a>.<\/p>\n<p>We are now ready to begin creating services in Microsoft Azure to facilitate storing and loading our dataset into Azure Cosmos DB.\u00a0 We will first create a Resource Group to serve as a container for storing the related services that will make up our solution.\u00a0 This can be accomplished by selecting the \u201cCreate a Resource\u201d option from the left menu in the Azure Portal, then searching for \u201cResource Group\u201d and choose the \u201cResource group\u201d result and select \u201cCreate\u201d.\u00a0 You will want to give your Resource Group a descriptive name like \u201c<em>Covid19Analysis<\/em>\u201d as depicted below.\u00a0 Choose an appropriate region then proceed with the steps to create the Resource Group.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-resource-group.png\"><img decoding=\"async\" class=\"alignnone wp-image-4837 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-resource-group.png\" alt=\"Create a resource group\" width=\"624\" height=\"334\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-resource-group.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-resource-group-300x161.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Next, we will create an Azure Storage Account where we use Blob Storage to upload and store our dataset.\u00a0 We will again select the \u201cCreate a Resource\u201d option from the left menu in the Azure Portal, then search for and select \u201cStorage Account\u201d.\u00a0 Select \u201cCreate\u201d and you will be presented with a screen requesting additional details as shown below:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-account.png\"><img decoding=\"async\" class=\"alignnone wp-image-4838 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-account.png\" alt=\"Create a storage account\" width=\"624\" height=\"783\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-account.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-account-239x300.png 239w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>You will want to ensure that you select the Resource Group that was created previously, choose a unique Storage account name (consisting of a combination of 3-24 lowercase characters and numbers), and deploy into the appropriate region.\u00a0 All other default settings can be left alone, proceed by selecting \u201cReview\u201d then \u201cCreate\u201d to create the Azure Storage Account.<\/p>\n<p>Navigate to the newly deployed resource, then underneath the \u201cData storage\u201d section, select \u201cContainers\u201d =&gt; \u201c+ Container\u201d then give the container a descriptive name like \u201cdatasets\u201d and select \u201cCreate\u201d as shown below:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-container.png\"><img decoding=\"async\" class=\"alignnone wp-image-4839 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-container.png\" alt=\"Create storage container\" width=\"624\" height=\"332\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-container.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-storage-container-300x160.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Select the newly created container, then choose \u201c<strong>Upload<\/strong>\u201d and provide the path to the downloaded COVID-19 case count dataset as shown, and select \u201c<strong>Upload<\/strong>\u201d as shown:\n<a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/upload-to-container.png\"><img decoding=\"async\" class=\"alignnone wp-image-4840 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/upload-to-container.png\" alt=\"Upload to container\" width=\"624\" height=\"163\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/upload-to-container.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/upload-to-container-300x78.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>The COVID-19 case count data is now available in Azure Blob Storage:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/data-in-blob-storage.png\"><img decoding=\"async\" class=\"alignnone wp-image-4841 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/data-in-blob-storage.png\" alt=\"Data in blob storage\" width=\"624\" height=\"162\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/data-in-blob-storage.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/data-in-blob-storage-300x78.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Now we are ready to create the Azure Cosmos DB instance where we will import this dataset.\u00a0 Begin by selecting the \u201cCreate a Resource\u201d option from the left menu in the Azure Portal, then search for \u201cAzure Cosmos DB\u201d, choose the \u201cAzure Cosmos DB\u201d result and select \u201cCreate\u201d.\u00a0 You will be presented with a prompt to select an API option.\u00a0 We will select the \u201cCreate\u201d within the \u201cCore (SQL) \u2013 Recommended\u201d option, however, it is important to note the variety of options that are available.\u00a0 In the resulting screen, select the Resource Group which was created earlier, then name your instance (using a combination of 3-44 letters, numbers, and \u2013\u2018s) and select the appropriate value for \u201cLocation.\u201d\u00a0 The remaining options can be left at default or modified depending on your preference.\u00a0 When you are ready select \u201cReview + create\u201d as shown:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db.png\"><img decoding=\"async\" class=\"alignnone wp-image-4842 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db.png\" alt=\"Create azure cosmos db\" width=\"624\" height=\"330\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db-300x159.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Once you have successfully validated your settings, you are now able to create the Azure Cosmos DB instance by selecting \u201cCreate\u201d:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-cosmos-db.png\"><img decoding=\"async\" class=\"alignnone wp-image-4843 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-cosmos-db.png\" alt=\"Validate azure cosmos db\" width=\"624\" height=\"595\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-cosmos-db.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-cosmos-db-300x286.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-cosmos-db-24x24.png 24w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Navigate to the newly deployed Azure Cosmos DB instance and select \u201cOverview\u201d, then choose \u201c+ Add Container\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-overview.png\"><img decoding=\"async\" class=\"alignnone wp-image-4844 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-overview.png\" alt=\"Azure cosmos db overview\" width=\"624\" height=\"199\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-overview.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-overview-300x96.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the resulting pane, select \u201cCreate new\u201d and name your database \u201cCovid19Data\u201d, leave all options below at their default value, then provide a value of \u201cCaseCount\u201d in the Container id field, and supply \u201c\/id\u201d for the value in the Partition key field.\u00a0 When you are finished, select \u201cOK\u201d to create the container.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db-container.png\"><img decoding=\"async\" class=\"alignnone wp-image-4845 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db-container.png\" alt=\"Create azure cosmos db container\" width=\"624\" height=\"326\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db-container.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-cosmos-db-container-300x157.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>We are now ready to begin the process of importing our Covid-19 dataset from Azure Storage into Azure Cosmos DB. To accomplish this, we will use Azure Data Factory.\u00a0 Start by selecting the \u201cCreate a Resource\u201d option from the left menu in the Azure Portal, then search for \u201cData Factory\u201d, choose the \u201cData Factory\u201d result and then select \u201cCreate\u201d.\u00a0 In the resulting prompt, provide the name of the Resource group that was crated earlier, name the instance, and provide an appropriate value for the Region field.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-data-factory.png\"><img decoding=\"async\" class=\"alignnone wp-image-4846 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-data-factory.png\" alt=\"Create azure data factory\" width=\"624\" height=\"650\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-data-factory.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-data-factory-288x300.png 288w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-azure-data-factory-24x24.png 24w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Select the \u201cGit Configuration\u201d tab and check the box next to \u201cConfigure Git later\u201d.\u00a0 We are now ready to validate the deployment by selecting \u201cReview + Create\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-data-factory-configure-git.png\"><img decoding=\"async\" class=\"alignnone wp-image-4847 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-data-factory-configure-git.png\" alt=\"Create data factory and configure git\" width=\"624\" height=\"659\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-data-factory-configure-git.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-data-factory-configure-git-284x300.png 284w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/create-data-factory-configure-git-24x24.png 24w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Once you have successfully validated your settings, you are now able to create the Azure Data Factory instance by selecting \u201cCreate\u201d:<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-data-factory.png\"><img decoding=\"async\" class=\"alignnone wp-image-4848 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-data-factory.png\" alt=\"Validate azure data factory\" width=\"624\" height=\"677\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-data-factory.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/validate-azure-data-factory-277x300.png 277w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Navigate to the newly deployed Azure Data Factory resource and select \u201cOpen Azure Data Factory Studio\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-studio.png\"><img decoding=\"async\" class=\"alignnone wp-image-4849 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-studio.png\" alt=\"Azure data factory studio\" width=\"624\" height=\"282\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-studio.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-studio-300x136.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the resulting window, select \u201cIngest\u201d to begin the process of importing our data from Azure Blob Storage into Azure Cosmos DB.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-ingest.png\"><img decoding=\"async\" class=\"alignnone wp-image-4850 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-ingest.png\" alt=\"Azure data factory ingest\" width=\"624\" height=\"195\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-ingest.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-data-factory-ingest-300x94.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Select \u201cBuilt-in copy task\u201d for Task Type and select \u201cRun once now\u201d for Task cadence or task schedule, then select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties.png\"><img decoding=\"async\" class=\"alignnone wp-image-4851 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties.png\" alt=\"Copy data tool properties\" width=\"624\" height=\"216\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties-300x104.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the Source data store prompt, select \u201cAzure Blob Storage\u201d for Source type then select \u201c+ New Connection\u201d.\u00a0 In the resulting pane, supply a value for Name, then for Authentication type choose \u201cAccount key\u201d \/ \u201cConnection string\u201d.\u00a0 For Account selection method choose \u201cFrom Azure subscription\u201d, then choose the appropriate value for \u201cAzure subscription\u201d and select the name of the storage account created in previous steps for \u201cStorage account name\u201d.\u00a0 In the Test connection area, choose \u201cTo linked service\u201d then select \u201cTest Connection\u201d to validate that the Connection is successful.\u00a0 When you are ready, select \u201cCreate\u201d to proceed.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties-new-connection.png\"><img decoding=\"async\" class=\"alignnone wp-image-4852 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties-new-connection.png\" alt=\"Copy data tool properties and create new connection\" width=\"624\" height=\"346\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties-new-connection.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-properties-new-connection-300x166.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>A new set of options will appear in the original prompt.\u00a0 Select \u201cBrowse\u201d and navigate to the uploaded COVID-19 case count dataset, ensure that \u201cRecursively\u201d is the only box checked under Options, then select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-source-data-store.png\"><img decoding=\"async\" class=\"alignnone wp-image-4853 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-source-data-store.png\" alt=\"Copy data tool source data store\" width=\"624\" height=\"540\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-source-data-store.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-source-data-store-300x260.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the resulting prompt, leave settings as default as shown below and select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-file-format-settings.png\"><img decoding=\"async\" class=\"alignnone wp-image-4854 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-file-format-settings.png\" alt=\"Copy data tool file format settings\" width=\"624\" height=\"549\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-file-format-settings.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-file-format-settings-300x264.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the Destination data store window, select \u201cAzure Cosmos DB (SQL API)\u201d for Destination type, then select \u201c+ New Connection\u201d.\u00a0 In the resulting pane, supply a value for Name, then for Authentication type choose \u201cAccount key\u201d \/ \u201cConnection string\u201d.\u00a0 For Account selection method choose \u201cFrom Azure subscription\u201d, then choose the appropriate value for \u201cAzure subscription\u201d and select the name of the Azure Cosmos DB account name created in previous steps (covid19analysiscosmos) then select the Database name that was created earlier (Covid19Data).\u00a0 In the Test connection area, choose \u201cTo linked service\u201d then select \u201cTest Connection\u201d to validate that the Connection is successful.\u00a0 When you are ready, select \u201cCreate\u201d to proceed.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-destination-data-store-new-connection.png\"><img decoding=\"async\" class=\"alignnone wp-image-4855 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-destination-data-store-new-connection.png\" alt=\"Copy data tool destination data store new connection\" width=\"624\" height=\"347\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-destination-data-store-new-connection.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-destination-data-store-new-connection-300x167.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>A new set of options will appear in the original prompt.\u00a0 In the \u201cTarget\u201d field, select \u201cCase Count\u201d to target the container of that name as the destination for the Covid case count CSV data.\u00a0 At the bottom of the prompt, ensure that \u201cSkip schema mapping for all tables\u201d is checked.\u00a0 When you are ready to proceed, select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-store-destination-data-store.png\"><img decoding=\"async\" class=\"alignnone wp-image-4856 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-store-destination-data-store.png\" alt=\"Copy data store destination data store\" width=\"624\" height=\"429\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-store-destination-data-store.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-store-destination-data-store-300x206.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the Schema mapping configuration pane, we can proceed directly by selecting \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-schema-mapping.png\"><img decoding=\"async\" class=\"alignnone wp-image-4857 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-schema-mapping.png\" alt=\"Copy data tool schema mapping\" width=\"624\" height=\"347\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-schema-mapping.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-schema-mapping-300x167.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the resulting window, provide a value of \u201cCopyCovid19DataFromBlogtoCosmos\u201d in the \u201cTask name\u201d field, then select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-settings.png\"><img decoding=\"async\" class=\"alignnone wp-image-4858 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-settings.png\" alt=\"Copy data tool settings\" width=\"624\" height=\"661\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-settings.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-settings-283x300.png 283w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-settings-24x24.png 24w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the resulting Summary window, ensure that your pipeline to copy data from Azure Blob Storage to Azure Cosmos DB (SQL API) is valid, then select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-summary.png\"><img decoding=\"async\" class=\"alignnone wp-image-4859 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-summary.png\" alt=\"Copy data tool summary\" width=\"624\" height=\"474\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-summary.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-summary-300x228.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>The Deployment process will begin.\u00a0 After a short period of time, you see a \u201cSucceeded\u201d status appear for each \u201cDeployment step\u201d.\u00a0 When you have validated the deployment as successful, select \u201cFinish\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-deployment.png\"><img decoding=\"async\" class=\"alignnone wp-image-4860 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-deployment.png\" alt=\"Copy data tool deployment\" width=\"624\" height=\"496\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-deployment.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/copy-data-tool-deployment-300x238.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Visualize Covid Case Count data into Azure Cosmos DB with Azure Synapse Link and the Integrated Power BI Experience<\/strong><\/p>\n<p>Now that the Azure Data Factory deployment process has been completed, we will verify that our data has been imported from Azure Blob Storage into Azure Cosmos DB. Navigate to the Cosmos DB resource and select \u201cData Explorer\u201d.\u00a0 In the resulting window, look for the tree view and expand the database node (Covid19Data), underneath this node expand the container node (CaseCount), and finally select the \u201cItems\u201d node.\u00a0 The screen will populate with \u201cid\u201d results, select one of these entries to view the data for that entry.\u00a0 You should see a result similar to the screenshot below.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-data-explorer.png\"><img decoding=\"async\" class=\"alignnone wp-image-4861 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-data-explorer.png\" alt=\"Azure cosmos db data explorer\" width=\"624\" height=\"333\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-data-explorer.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-data-explorer-300x160.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Now that we have verified our data was successfully imported into Azure Cosmos DB, we are ready to prepare our data for visualization in Power BI.\u00a0 On the left-hand side, scroll down to \u201cIntegrations\u201d and select \u201cPower BI\u201d.\u00a0 A prompt will appear asking to \u201cEnable Azure Synapse Link for this account\u201d.\u00a0 Select \u201cEnable\u201d to proceed.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link.png\"><img decoding=\"async\" class=\"alignnone wp-image-4862 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link.png\" alt=\"Azure cosmos db enable synapse link\" width=\"624\" height=\"325\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link-300x156.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>When the \u201cEnabling\u201d task has completed, check the Covid19Data and CaseCount checkboxes to enable Azure Synapse Link for this container.\u00a0 Select \u201cNext\u201d to proceed.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link-for-container.png\"><img decoding=\"async\" class=\"alignnone wp-image-4863 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link-for-container.png\" alt=\"Azure cosmos db enable synapse link for container\" width=\"624\" height=\"566\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link-for-container.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-enable-synapse-link-for-container-300x272.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the \u201cSelect Azure Synapse Analytics Workspace\u201d prompts, choose the appropriate value for your Azure subscription, then select \u201cCreate new\u201d in the \u201cWorkspace\u201d section.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace.png\"><img decoding=\"async\" class=\"alignnone wp-image-4865 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace.png\" alt=\"Azure cosmos db select synapse workspace\" width=\"624\" height=\"424\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-300x204.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the \u201cCreate Synapse workspace\u201d prompt, select the appropriate \u201cSubscription\u201d and \u201cResource group\u201d.\u00a0 Optionally, you can name the \u201cManaged resource group\u201d something descriptive as shown.\u00a0 Select the appropriate value for \u201cRegion\u201d.\u00a0 Next, provide a descriptive \u201cWorkspace name\u201d and ensure that the \u201cFrom subscription\u201d option is checked.\u00a0 In the \u201cAccount name\u201d field, select \u201cCreate new\u201d and provide a name as shown and repeat the process for the \u201cFile system name field\u201d.\u00a0 When you have completed these steps, select the &#8220;Security&#8221; tab.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synape-workspace.png\"><img decoding=\"async\" class=\"alignnone wp-image-4866 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synape-workspace.png\" alt=\"Azure cosmos db create synape workspace\" width=\"624\" height=\"749\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synape-workspace.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synape-workspace-250x300.png 250w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Check the option for &#8220;Use both local an Azure Active Dreictory (Azure AD) authentication&#8221;, then provide a &#8220;SQL Server admin login&#8221; and &#8220;SQL Password&#8221; .\u00a0 When you are ready to proceed, select \u201cReview + Create\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-security.png\"><img decoding=\"async\" class=\"alignnone wp-image-4867 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-security.png\" alt=\"Azure cosmos db create synapse workspace security\" width=\"962\" height=\"909\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-security.png 962w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-security-300x283.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-security-768x726.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-security-24x24.png 24w\" sizes=\"(max-width: 962px) 100vw, 962px\" \/><\/a><\/p>\n<p>Next, the deployment options will be validated.\u00a0 Once you have confirmed that the validation has succeeded, select \u201cCreate\u201d to deploy the Azure Synapse workspace.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-validate.png\"><img decoding=\"async\" class=\"alignnone wp-image-4869 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-validate.png\" alt=\"Azure cosmos db create synapse workspace validate\" width=\"974\" height=\"909\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-validate.png 974w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-validate-300x280.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-create-synapse-workspace-validate-768x717.png 768w\" sizes=\"(max-width: 974px) 100vw, 974px\" \/><\/a><\/p>\n<p>Once the deployment has completed successfully, we will navigate back to our Azure Cosmos DB resource.\u00a0 On the left-hand side, scroll down to \u201cIntegrations\u201d and select \u201cPower BI\u201d.\u00a0 A prompt will appear asking to \u201cEnable Azure Synapse Link for this account\u201d and should show as \u201cAccount enabled\u201d.\u00a0 Select \u201cNext\u201d to proceed.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-synapse-link-enabled.png\"><img decoding=\"async\" class=\"alignnone wp-image-4870 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-synapse-link-enabled.png\" alt=\"Azure cosmos db synapse link enabled\" width=\"624\" height=\"592\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-synapse-link-enabled.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-synapse-link-enabled-300x285.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-synapse-link-enabled-24x24.png 24w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the \u201cSelect Azure Synapse Analytics Workspace\u201d prompt, choose the appropriate value for your Azure subscription, then select the newly created workspace in the \u201cWorkspace\u201d area.\u00a0 In the \u201cDatabase\u201d area, select \u201cCreate new\u201d and supply a name for the new Azure Synapse Database then select \u201cCreate\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database.png\"><img decoding=\"async\" class=\"alignnone wp-image-4871 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database.png\" alt=\"Azure cosmos db select synapse workspace database\" width=\"624\" height=\"330\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database-300x159.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Select the newly created database in the \u201cDatabase\u201d area, then select \u201cNext\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database-select.png\"><img decoding=\"async\" class=\"alignnone wp-image-4872 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database-select.png\" alt=\"Azure cosmos db select synapse workspace database \" width=\"624\" height=\"565\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database-select.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-select-synapse-workspace-database-select-300x272.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Next, you will be prompted to download a .pbids file that is ready to connect to your Azure Cosmos DB instance.\u00a0 Select \u201cDownload.pbids\u201d and open the file in Power BI Desktop.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-power-bi-pbid-download.png\"><img decoding=\"async\" class=\"alignnone wp-image-4873 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-power-bi-pbid-download.png\" alt=\"Azure cosmos db power bi pbid download\" width=\"624\" height=\"381\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-power-bi-pbid-download.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/azure-cosmos-db-power-bi-pbid-download-300x183.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>The file should open successfully, and you will be asked to securely authenticate the database connection.\u00a0 In the resulting prompt, select \u201cMicrosoft account\u201d for authentication then select \u201cSign in\u201d and sign in with the credentials used to access your Azure subscription.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/open-pbid-in-power-bi-desktop.png\"><img decoding=\"async\" class=\"alignnone wp-image-4874 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/open-pbid-in-power-bi-desktop.png\" alt=\"Open pbid in power bi desktop\" width=\"624\" height=\"336\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/open-pbid-in-power-bi-desktop.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/open-pbid-in-power-bi-desktop-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Once you have successfully signed in, select \u201cConnect\u201d<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-connect-data-source.png\"><img decoding=\"async\" class=\"alignnone wp-image-4875 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-connect-data-source.png\" alt=\"Power bi connect data source\" width=\"624\" height=\"335\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-connect-data-source.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-connect-data-source-300x161.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>In the resulting Navigator window, select the \u201cCovid19Data_CaseCount\u201d entry, then select \u201cLoad\u201d.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-load-data-source.png\"><img decoding=\"async\" class=\"alignnone wp-image-4876 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-load-data-source.png\" alt=\"Power bi load data source\" width=\"624\" height=\"336\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-load-data-source.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-load-data-source-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Once the dataset has successfully loaded into Power BI, select the \u201cCASE_COUNT\u201d column in the \u201cFields\u201d tab on the right-hand side of the screen.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-case-count-column.png\"><img decoding=\"async\" class=\"alignnone wp-image-4877 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-case-count-column.png\" alt=\"Power bi case count column\" width=\"624\" height=\"336\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-case-count-column.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-case-count-column-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>All of our columns are currently being treated as Data type of \u201cText\u201d, we will change the CASE_COUNT to be of Data type \u201cWhole number\u201d by selecting the Data type field in the upper-left corner of the screen and selecting \u201cWhole number\u201d in the dropdown list.\u00a0 You will be prompted to verify this change.\u00a0 Once it has been applied successfully, you should see the Data type has changed to \u201cWhole Number\u201d for this column.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-change-data-type.png\"><img decoding=\"async\" class=\"alignnone wp-image-4878 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-change-data-type.png\" alt=\"Power bi change data type\" width=\"624\" height=\"336\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-change-data-type.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-change-data-type-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Next, we will select the \u201cdata_of_interest\u201d column located in the \u201cFields\u201d tab. We will change the Data type of this entity to \u201cData\/time\u201d.\u00a0 Selecting appropriate Data types for our columns will allow them to render appropriately when plotting as time series data.\u00a0 To begin plotting our data, we will select the \u201cLine chart\u201d item under the \u201cVisualizations\u201d area.\u00a0 Expand the visualization as needed and you should see a result similar to the screenshot below.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-visualizations.png\"><img decoding=\"async\" class=\"alignnone wp-image-4879 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-visualizations.png\" alt=\"Power bi visualizations\" width=\"624\" height=\"336\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-visualizations.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-visualizations-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Now select the \u201cdate_of_interest\u201d column in the \u201cFields\u201d section and drag and drop it to the \u201cX-axis\u201d section under visualizations.\u00a0 Similarly, drag and drop the \u201cCASE_COUNT\u201d column into the \u201cY-axis\u201d section.\u00a0 The data should plot as shown below, depicting the infamous Covid case spike that occurred in December \/ January 2022.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-axes.png\"><img decoding=\"async\" class=\"alignnone wp-image-4880 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-axes.png\" alt=\"Power bi axes\" width=\"624\" height=\"337\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-axes.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-axes-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>Congratulations!\u00a0 At this point you have successfully plotted the Covid case count data and are well on your way to developing your own analyses using data sources loaded from Azure Cosmos DB.\u00a0 Below we show an example using additional data from <a href=\"https:\/\/data.cityofnewyork.us\/Public-Safety\/NYPD-Complaint-Data-Current-Year-To-Date-\/5uac-w243\">NYPD Complaint Data from the NYC Open Data store<\/a> to correlate crime statistics with COVID-19 case counts.<\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-crime-statistics.png\"><img decoding=\"async\" class=\"alignnone wp-image-4881 size-full\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-crime-statistics.png\" alt=\"Power bi crime statistics\" width=\"624\" height=\"336\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-crime-statistics.png 624w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/09\/power-bi-crime-statistics-300x162.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Conclusion<\/strong><\/p>\n<p>In this article we have demonstrated how to successfully perform Extract, Transform, and Load (ETL) operations by extracting and loading data from <a href=\"https:\/\/azure.microsoft.com\/free\/storage?WT.mc_id=data-74141-pdecarlo\">Azure Blob Storage<\/a> into <a href=\"https:\/\/azure.microsoft.com\/free\/cosmos-db?WT.mc_id=data-74141-pdecarlo\">Azure Cosmos DB<\/a> using <a href=\"https:\/\/azure.microsoft.com\/services\/data-factory?WT.mc_id=data-74141-pdecarlo\">Azure Data Factory<\/a>.\u00a0 We then Transformed and reloaded that data for visualization suing the <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/integrated-power-bi-synapse-link?WT.mc_id=data-74141-pdecarlo\">Integrated Power BI Experience<\/a> enabled by the <a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/synapse-link?WT.mc_id=data-74141-pdecarlo\">Azure Synapse Link for Azure Cosmos DB<\/a>.\u00a0 These steps will enable you to go forth to develop your own unique analyses against the <a href=\"https:\/\/catalog.data.gov\/dataset\/covid-19-daily-counts-of-cases-hospitalizations-and-deaths\">COVID-19 Daily Counts of Cases, Hospitalizations, and Deaths<\/a> dataset.<\/p>\n<p>If you are interested in learning more about some of the analyses that were developed during the Hackathon, check out the following resources:<\/p>\n<ul>\n<li><a href=\"https:\/\/techcommunity.microsoft.com\/t5\/ai-machine-learning-blog\/using-azure-machine-learning-in-winning-the-microsoft-amp-oxford\/ba-p\/3586477?WT.mc_id=data-74141-pdecarlo\">Using Azure Machine Learning in winning the Microsoft &amp; Oxford&#8217;s Tale of Two Cities Hackathon &#8211; Microsoft Tech Community<\/a><\/li>\n<li><a href=\"https:\/\/observablehq.com\/@observablehq\/microsoft-reactor-hackathon?utm_medium=event&amp;utm_campaign=msft_hack&amp;utm_source=partner_event\">Microsoft Reactor Hackathon \/ Observable \/ Observable (observablehq.com)<\/a><\/li>\n<\/ul>\n<p>For additional tutorials that make use of the services used in this article, take a look at this handy collection of materials from Microsoft Learn.<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/explore-azure-blob-storage\/?WT.mc_id=data-74141-pdecarlo\">Explore Azure Blob storage &#8211; Learn | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/paths\/get-started-azure-cosmos-db-sql-api\/?WT.mc_id=data-74141-pdecarlo\">Get started with Azure Cosmos DB SQL API &#8211; Learn | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/paths\/plan-implement-azure-cosmos-db-sql-api\/?WT.mc_id=data-74141-pdecarlo\">Plan and implement Azure Cosmos DB SQL API &#8211; Learn | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/intro-to-azure-data-factory\/?WT.mc_id=data-74141-pdecarlo\">Introduction to Azure Data Factory &#8211; Learn | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/configure-azure-synapse-link-with-azure-cosmos-db\/?WT.mc_id=data-74141-pdecarlo\">Implement Azure Synapse Link with Azure Cosmos DB &#8211; Learn | Microsoft Docs<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/learn\/modules\/get-started-with-power-bi\/?WT.mc_id=data-74141-pdecarlo\">Get started building with Power BI &#8211; Learn | Microsoft Docs<\/a><\/li>\n<\/ul>\n<p>Until next time, Happy Hacking!<\/p>\n<p>-Paul DeCarlo<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How have major cities like London and New York been affected by Covid-19 and how can we use historical data to explore how these effects might impact us in a post-Covid world?\u00a0 This was the question posed at a Microsoft Data + AI Hackathon held in partnership with the University of Oxford and Observable HQ [&hellip;]<\/p>\n","protected":false},"author":833,"featured_media":4836,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[14],"tags":[],"class_list":["post-4834","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-core-sql-api"],"acf":[],"blog_post_summary":"<p>How have major cities like London and New York been affected by Covid-19 and how can we use historical data to explore how these effects might impact us in a post-Covid world?\u00a0 This was the question posed at a Microsoft Data + AI Hackathon held in partnership with the University of Oxford and Observable HQ [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/4834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/users\/833"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=4834"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/4834\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/4836"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=4834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=4834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=4834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}