{"id":4064,"date":"2022-03-30T08:55:14","date_gmt":"2022-03-30T15:55:14","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=4064"},"modified":"2022-04-08T07:41:49","modified_gmt":"2022-04-08T14:41:49","slug":"azure-synapse-link-existing-containers-and-power-bi-integration","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/azure-synapse-link-existing-containers-and-power-bi-integration\/","title":{"rendered":"Azure Synapse Link: Announcing support for existing Azure Cosmos DB containers and seamless Power BI integration"},"content":{"rendered":"<p><i><span data-contrast=\"none\">This blog post was co-authored by Rodrigo Souza and Anitha Adusumilli from the Azure Cosmos DB Team.<\/span><\/i><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Today we are announcing General Availability of Azure Synapse Link for existing Azure Cosmos DB containers. Using Azure Synapse Link, you can also now build Power BI dashboards with just a few clicks from Azure Cosmos DB portal. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/synapse-link-power-bi?context=\/azure\/synapse-analytics\/context\/context\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Azure Synapse Link for Azure Cosmos DB<\/span><\/a><span data-contrast=\"auto\"> is a cloud-native hybrid transactional and analytical processing (HTAP) capability that enables near real time analytics over operational data in Azure Cosmos DB.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h2 aria-level=\"2\"><span data-contrast=\"none\">Azure Synapse Link for existing Azure Cosmos containers<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">You can now enable analytical store and unlock Synapse Link for your existing Cosmos containers, which will trigger the initial sync of the data from transactional store to analytical store. There is no cost or performance impact on your transactional workloads, and you can do it using the Azure Portal, Azure Cosmos DB SDKs, Azure CLI, or PowerShell.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The sync process may last from seconds to days, depending on your data volume. You can check the progress in the Azure Portal, using the new left navigation item for Azure Synapse Link, located in the <\/span><b><span data-contrast=\"auto\">Integrations<\/span><\/b><span data-contrast=\"auto\"> section. The image below shows you how to locate the Azure Synapse Link left navigation item and monitor the progress of your initial synchronization.<\/span><\/p>\n<p><a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4067\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834.png\" alt=\"Image Screenshot 2022 03 29 121834\" width=\"1554\" height=\"772\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834.png 1554w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834-300x149.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834-1024x509.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834-768x382.png 768w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121834-1536x763.png 1536w\" sizes=\"(max-width: 1554px) 100vw, 1554px\" \/><\/a><\/p>\n<p><span data-contrast=\"auto\">Please note that:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">This new feature is only available for Azure Cosmos DB SQL API. The same capability for collections using our MongoDB API for Azure Cosmos DB is on our roadmap.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">If you are using Azure Cosmos DB SDKs, Azure CLI, or PowerShell, analytical store is enabled by simply setting the analytical TTL property to -1, meaning that data is kept in the analytical store indefinitely, or to any positive integer, that is the number of seconds that the data will be kept in analytical store. As an example, if you set analytical TTL to 31536000, your data will be kept in analytical store for 1 year.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">You can enable Synapse Link on multiple containers in an account at the same time.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">You won\u2019t be able to use Synapse Link on containers while initial sync is in progress between transactional and analytical store.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<ul>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">Once Synapse Link is enabled on your container, you can analyze the data in your container by using <\/span><a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/configure-synapse-link#query-analytical-store-spark\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Synapse Spark<\/span><\/a><span data-contrast=\"auto\"> or <\/span><a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/configure-synapse-link#query-analytical-store-sql-on-demand\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Synapse serverless SQL pools<\/span><\/a><span data-contrast=\"auto\">. You can directly access your Cosmos DB container\u2019s analytical store data in multiple Synapse workspaces. There\u2019s no cost or performance impact on your OLTP workloads when using Synapse Link.\u00a0\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">You can also disable analytical store using PowerShell. You cannot re-enable analytical store once disabled. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Click <\/span><a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/configure-synapse-link\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">here<\/span><\/a><span data-contrast=\"auto\"> to learn more on how to configure and use Azure Synapse Link for Azure Cosmos DB, including how to enable analytical store on existing containers.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h2 aria-level=\"2\"><span data-contrast=\"none\">Integrated Azure Synapse Link Power BI experience<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">With the integrated Power BI experience in the Azure Cosmos DB portal, you can visualize your Azure Cosmos DB data in near real time in just a few clicks. Synapse Link enables you to build Power BI reports and dashboards with no performance or cost impact to your transactional workloads, and no ETL pipelines. You can either use <\/span><a href=\"https:\/\/docs.microsoft.com\/power-bi\/connect-data\/service-dataset-modes-understand#directquery-mode\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">DirectQuery<\/span><\/a><span data-contrast=\"auto\"> or <\/span><a href=\"https:\/\/docs.microsoft.com\/power-bi\/connect-data\/service-dataset-modes-understand#import-mode\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">import<\/span><\/a><span data-contrast=\"auto\"> modes. With DirectQuery, Power BI can query live data from your Azure Cosmos DB accounts, without importing or copying the data into Power BI.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">To get started:\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<ul>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">Step 1: Click on \u201cPower BI\u201d under \u201cIntegrations\u201d in the Azure Cosmos DB portal. Select containers to start building your BI dashboard. If the containers are not enabled with Synapse Link, you will need to enable this before you can proceed further.\u00a0 It may take some time for the initial sync of transactional store to analytical store.\u00a0 <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">Step 2: Pick your <\/span><a href=\"https:\/\/docs.microsoft.com\/azure\/synapse-analytics\/get-started-create-workspace\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">Synapse workspace<\/span><\/a><span data-contrast=\"auto\"> and serverless SQL pool database. Using Synapse Link, this step will automatically create T-SQL views for the Cosmos DB containers you\u2019ve selected.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<li data-leveltext=\"-\" data-font=\"Calibri\" data-listid=\"1\" aria-setsize=\"-1\" data-aria-posinset=\"0\" data-aria-level=\"1\"><span data-contrast=\"auto\">Step 3: You can directly now download <\/span><a href=\"https:\/\/docs.microsoft.com\/power-bi\/create-reports\/service-export-to-pbix\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"auto\">.pbix file<\/span><\/a><span data-contrast=\"auto\">, which is initialized with your Synapse SQL connection credentials and with all the T-SQL views included as data sources. <\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335551550&quot;:6,&quot;335551620&quot;:6,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Clicking on the .pbix file opens Power BI Desktop. That\u2019s it \u2013 with just a few clicks, you can now start creating your BI reports.\u00a0<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:720,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559685&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\"> <a href=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121927.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4066\" src=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121927.png\" alt=\"Image Screenshot 2022 03 29 121927\" width=\"1315\" height=\"736\" srcset=\"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121927.png 1315w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121927-300x168.png 300w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121927-1024x573.png 1024w, https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-content\/uploads\/sites\/52\/2022\/03\/Screenshot-2022-03-29-121927-768x430.png 768w\" sizes=\"(max-width: 1315px) 100vw, 1315px\" \/><\/a><\/span><\/p>\n<p><span data-contrast=\"auto\">Learn more about integrated Power BI experience in Azure Cosmos DB portal <\/span><a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/integrated-power-bi-synapse-link\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">here<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<h2 aria-level=\"2\"><span data-contrast=\"none\">Next steps<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559738&quot;:40,&quot;335559739&quot;:0,&quot;335559740&quot;:259}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"none\">To get started with Azure Synapse Link, please see our <\/span><a href=\"https:\/\/docs.microsoft.com\/azure\/cosmos-db\/configure-synapse-link\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">documentation<\/span><\/a><span data-contrast=\"none\">.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:0,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">You can also use our sample published on\u202f<\/span><a href=\"https:\/\/aka.ms\/cosmosdb-synapselink-sql-samples\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">GitHub<\/span><\/a><span data-contrast=\"none\">.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:true,&quot;201341983&quot;:0,&quot;335559738&quot;:0,&quot;335559740&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"none\">For any feedback or suggestions to improve our product offering, please reach out to us directly at\u202f<\/span><a href=\"mailto:cosmosdbsynapselink@microsoft.com\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">cosmosdbsynapselink@microsoft.com<\/span><\/a><span data-contrast=\"none\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Azure Synapse Link: Announcing support for existing Azure Cosmos DB containers and seamless Power BI integration. <\/p>\n","protected":false},"author":21894,"featured_media":1211,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1610,1216,12,14,818],"tags":[1242,1802,1811,1234,1740,287,957,1791,1792,1790,1810,1230,1620],"class_list":["post-4064","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ai","category-analytics","category-announcements","category-core-sql-api","category-query","tag-analytics","tag-announcement","tag-announcements","tag-bi","tag-cosmos","tag-cosmos-db","tag-cosmosdb","tag-data-engineering","tag-data-exploration","tag-data-science","tag-power-bi","tag-synapse","tag-synapse-link"],"acf":[],"blog_post_summary":"<p>Azure Synapse Link: Announcing support for existing Azure Cosmos DB containers and seamless Power BI integration. <\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/4064","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\/21894"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/comments?post=4064"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/posts\/4064\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media\/1211"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/media?parent=4064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/categories?post=4064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/cosmosdb\/wp-json\/wp\/v2\/tags?post=4064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}