{"id":8128,"date":"2020-01-31T06:40:07","date_gmt":"2020-01-31T14:40:07","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=8128"},"modified":"2025-06-13T18:21:25","modified_gmt":"2025-06-14T01:21:25","slug":"extend-couchbase-analytics-with-power-bi-using-cdata","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/","title":{"rendered":"Extend Couchbase Analytics with Power BI using CData"},"content":{"rendered":"<h2>Extend Couchbase Analytics with Power BI using CData.<\/h2>\n<p>This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData Power BI driver for Couchbase. More details regarding this driver can be <a href=\"https:\/\/www.cdata.com\/kb\/tech\/couchbase-powerbi.rst\">found here<\/a>.<\/p>\n<h3>Prerequisites<\/h3>\n<h4>Couchbase<\/h4>\n<p>You will first need a Couchbase Server Enterprise Edition (EE) 6.x cluster with the Data and Analytic services enabled. I am using a single node local install of Couchbase Server EE but the information in this article applies to any Couchbase Server EE cluster.<\/p>\n<p>If you do not have an existing Couchbase Server EE cluster, the following links will get you up and running quickly:<\/p>\n<ol>\n<li><a href=\"https:\/\/www.couchbase.com\/downloads\/\">Download Couchbase Server EE<\/a><\/li>\n<li>Install Couchbase Server EE\n<ul>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/macos-install.html\">Mac OS X<\/a><\/li>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/install-linux.html\">Linux<\/a><\/li>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/install\/install-package-windows.html\">Windows<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"https:\/\/docs.couchbase.com\/server\/6.0\/manage\/manage-nodes\/create-cluster.html#provision-a-node-with-the-ui\">Provision a single-node cluster<\/a>\u00a0(NOTE: use the default values for cluster configuration)<\/li>\n<\/ol>\n<h4>Windows Box<\/h4>\n<p>Using a windows based platform with the following details:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-7845\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM.png\" alt=\"\" width=\"371\" height=\"348\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM.png 650w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM-300x282.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/11\/Screen-Shot-2019-11-13-at-12.27.30-PM-20x20.png 20w\" sizes=\"auto, (max-width: 371px) 100vw, 371px\" \/><\/p>\n<h3>Couchbase Setup<\/h3>\n<p>In Couchbase click on <em>Settings\u00a0<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-7460\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/Settings-282x300.png\" alt=\"\" width=\"282\" height=\"300\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings-282x300.png 282w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings-300x319.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings-20x20.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Settings.png 317w\" sizes=\"auto, (max-width: 282px) 100vw, 282px\" \/><\/p>\n<p>Then <em>Sample Buckets<\/em><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-7459\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/Sample-300x99.png\" alt=\"\" width=\"300\" height=\"99\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Sample-300x99.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Sample-20x7.png 20w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/Sample.png 386w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>The select the beer-sample checkbox and select <em>Load Sample Data.\u00a0 <\/em>You can then navigate back to your<em> Buckets<\/em> and see <em>beer-sample.<\/em><\/p>\n<p>Once this is complete, we will need to setup Analytics.<\/p>\n<p>Select\u00a0<em>Analytics, <\/em>then create the shadow dataset of <em>beers <\/em>from the bucket of <em>beer-sample.<\/em><\/p>\n<div id=\"attachment_7463\" style=\"width: 754px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-7463\" class=\"wp-image-7463 size-full\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2019\/08\/analytics-2.png\" alt=\"Create Dataset in Couchbase Analytics\" width=\"744\" height=\"564\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/analytics-2.png 744w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/analytics-2-300x227.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/08\/analytics-2-20x15.png 20w\" sizes=\"auto, (max-width: 744px) 100vw, 744px\" \/><p id=\"caption-attachment-7463\" class=\"wp-caption-text\">Create Dataset in Couchbase Analytics<\/p><\/div>\n<pre class=\"lang:default decode:true\">CREATE DATASET beers ON `beer-sample` WHERE `type` = \"beer\";<\/pre>\n<p>Click\u00a0<em>Execute,\u00a0<\/em>this will crate the shadow dataset definition.<\/p>\n<p>I want to repeat this step by creating a second shadow dataset with the following definition.<\/p>\n<pre class=\"lang:default decode:true\">CREATE DATASET breweries ON `beer-sample` WHERE `type` = \"brewery\";<\/pre>\n<p>Next you will want to initialize it by activating the dataset with the following.<\/p>\n<pre class=\"lang:default decode:true \">CONNECT LINK Local;<\/pre>\n<p>Click Execute.<\/p>\n<p>You can now test this out within the Analytics dashboard by running something like the following.<\/p>\n<pre class=\"lang:default decode:true\">SELECT COUNT(*) FROM beers\r\nUNION ALL\r\nSELECT COUNT(*) FROM breweries;<\/pre>\n<p>More about Couchbase Analytics can be <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">found here.<\/a><\/p>\n<p>Your setup for Couchbase is complete!<\/p>\n<h3>Power BI Desktop Setup<\/h3>\n<p>I installed Power BI Desktop with all the defaults which can be <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/desktop\/\">found here<\/a>.<\/p>\n<p><span style=\"font-weight: 400\">Install CData Power BI Driver for Couchbase. (<a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/powerbi\/\">found here<\/a>)<\/span><\/p>\n<p><span style=\"font-weight: 400\">Setup the Power BI Connector Driver<\/span><\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">I set the following parameters<\/span>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Data Source Name: CData Power BI Source<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">User: Administrator<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Password:password<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Server: 13.92.234.252<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Analytics Port: 8095<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Verbosity: 5<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Dataverse: Default<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\">Flatten Arrays: 4<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-8134\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/01\/couchbase-power-bi.png\" alt=\"\" width=\"546\" height=\"546\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/couchbase-power-bi.png 546w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/couchbase-power-bi-300x300.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/couchbase-power-bi-150x150.png 150w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/couchbase-power-bi-65x65.png 65w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/couchbase-power-bi-50x50.png 50w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/couchbase-power-bi-20x20.png 20w\" sizes=\"auto, (max-width: 546px) 100vw, 546px\" \/><\/p>\n<p>Open Power BI Desktop and click Get Data -&gt; Other -&gt; CData Couchbase.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8129\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/01\/CData-Power-BI-Connector-for-Couchbase.png\" alt=\"\" width=\"503\" height=\"280\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/CData-Power-BI-Connector-for-Couchbase.png 974w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/CData-Power-BI-Connector-for-Couchbase-300x167.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/CData-Power-BI-Connector-for-Couchbase-768x427.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/CData-Power-BI-Connector-for-Couchbase-20x11.png 20w\" sizes=\"auto, (max-width: 503px) 100vw, 503px\" \/><\/p>\n<p>Once you have the queries you want to report on, create new reports!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8130\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.09-AM.png\" alt=\"\" width=\"493\" height=\"260\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.09-AM.png 948w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.09-AM-300x158.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.09-AM-768x405.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.09-AM-20x11.png 20w\" sizes=\"auto, (max-width: 493px) 100vw, 493px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-8131\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.34-AM.png\" alt=\"\" width=\"489\" height=\"364\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.34-AM.png 944w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.34-AM-300x223.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.34-AM-768x571.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2020\/01\/Screen-Shot-2020-01-31-at-9.32.34-AM-20x15.png 20w\" sizes=\"auto, (max-width: 489px) 100vw, 489px\" \/><\/p>\n<h3>Next Steps<\/h3>\n<p>Try creating a Power Bi report by sourcing data from Couchbase.<\/p>\n<p><a href=\"https:\/\/docs.couchbase.com\/server\/current\/getting-started\/do-a-quick-install.html\">Download Couchbase<\/a>, setup <a href=\"https:\/\/docs.couchbase.com\/server\/current\/learn\/services-and-indexes\/services\/analytics-service.html\">Analytics<\/a>, and start using Power BI Desktop with your data and see what insights you can gleam.\u00a0 Extend Analytics with other tools using the many <a href=\"https:\/\/www.cdata.com\/drivers\/couchbase\/\">Couchbase CData drivers<\/a> that are at your fingertips.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Extend Couchbase Analytics with Power BI using CData. This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData Power BI driver for Couchbase. More details regarding this [&hellip;]<\/p>\n","protected":false},"author":42713,"featured_media":6968,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[2242,2294,1812],"tags":[2369],"ppma_author":[9087],"class_list":["post-8128","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-connectors","category-analytics","category-n1ql-query","tag-cdata"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.7.1 (Yoast SEO v25.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Extend Couchbase Analytics with Power BI using CData - The Couchbase Blog<\/title>\n<meta name=\"description\" content=\"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData driver.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extend Couchbase Analytics with Power BI using CData\" \/>\n<meta property=\"og:description\" content=\"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData driver.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-31T14:40:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T01:21:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png\" \/>\n\t<meta property=\"og:image:width\" content=\"898\" \/>\n\t<meta property=\"og:image:height\" content=\"331\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Justin Simpson, Solutions Engineer, Couchbase\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Justin Simpson, Solutions Engineer, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\"},\"author\":{\"name\":\"Justin Simpson, Solutions Engineer, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291\"},\"headline\":\"Extend Couchbase Analytics with Power BI using CData\",\"datePublished\":\"2020-01-31T14:40:07+00:00\",\"dateModified\":\"2025-06-14T01:21:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\"},\"wordCount\":428,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png\",\"keywords\":[\"CData\"],\"articleSection\":[\"Connectors\",\"Couchbase Analytics\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\",\"name\":\"Extend Couchbase Analytics with Power BI using CData - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png\",\"datePublished\":\"2020-01-31T14:40:07+00:00\",\"dateModified\":\"2025-06-14T01:21:25+00:00\",\"description\":\"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData driver.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png\",\"width\":898,\"height\":331,\"caption\":\"data analytics dashboard tableau couchbase blog\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extend Couchbase Analytics with Power BI using CData\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291\",\"name\":\"Justin Simpson, Solutions Engineer, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/bd98e55f5b73d759274a5de5f96c5095\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g\",\"caption\":\"Justin Simpson, Solutions Engineer, Couchbase\"},\"description\":\"Justin Simpson is a Solutions Engineer at Couchbase and has been working in IT and technology since 2004. He is based in the Cincinnati, Ohio area.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/justin-simpson-158ba44\/\"],\"url\":\"https:\/\/www.couchbase.com\/blog\/author\/justin-simpson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Extend Couchbase Analytics with Power BI using CData - The Couchbase Blog","description":"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData driver.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/","og_locale":"en_US","og_type":"article","og_title":"Extend Couchbase Analytics with Power BI using CData","og_description":"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData driver.","og_url":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/","og_site_name":"The Couchbase Blog","article_published_time":"2020-01-31T14:40:07+00:00","article_modified_time":"2025-06-14T01:21:25+00:00","og_image":[{"width":898,"height":331,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png","type":"image\/png"}],"author":"Justin Simpson, Solutions Engineer, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Justin Simpson, Solutions Engineer, Couchbase","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/"},"author":{"name":"Justin Simpson, Solutions Engineer, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291"},"headline":"Extend Couchbase Analytics with Power BI using CData","datePublished":"2020-01-31T14:40:07+00:00","dateModified":"2025-06-14T01:21:25+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/"},"wordCount":428,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png","keywords":["CData"],"articleSection":["Connectors","Couchbase Analytics","SQL++ \/ N1QL Query"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/","url":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/","name":"Extend Couchbase Analytics with Power BI using CData - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png","datePublished":"2020-01-31T14:40:07+00:00","dateModified":"2025-06-14T01:21:25+00:00","description":"This article will guide you through the steps needed to setup the connection from Couchbase Analytics to Power BI Desktop using the CData driver.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2019\/05\/analytics-tableau-dashboarding-blog.png","width":898,"height":331,"caption":"data analytics dashboard tableau couchbase blog"},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/extend-couchbase-analytics-with-power-bi-using-cdata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Extend Couchbase Analytics with Power BI using CData"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"The Couchbase Blog","description":"Couchbase, the NoSQL Database","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"The Couchbase Blog","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/a0f07ddb4bcf033d9bab0edbfcd26291","name":"Justin Simpson, Solutions Engineer, Couchbase","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/bd98e55f5b73d759274a5de5f96c5095","url":"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g","caption":"Justin Simpson, Solutions Engineer, Couchbase"},"description":"Justin Simpson is a Solutions Engineer at Couchbase and has been working in IT and technology since 2004. He is based in the Cincinnati, Ohio area.","sameAs":["https:\/\/www.linkedin.com\/in\/justin-simpson-158ba44\/"],"url":"https:\/\/www.couchbase.com\/blog\/author\/justin-simpson\/"}]}},"authors":[{"term_id":9087,"user_id":42713,"is_guest":0,"slug":"justin-simpson","display_name":"Justin Simpson, Solutions Engineer, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/a25a380db8c128c63a22d40823fdc256c1ebfbd630d7f36716268bde406dfddd?s=96&d=mm&r=g","author_category":"","last_name":"Simpson, Solutions Engineer, Couchbase","first_name":"Justin","job_title":"","user_url":"","description":"Justin Simpson is a Solutions Engineer at Couchbase and has been working in IT and technology since 2004. He is based in the Cincinnati, Ohio area."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/8128","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/users\/42713"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/comments?post=8128"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/posts\/8128\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media\/6968"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/media?parent=8128"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/categories?post=8128"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/tags?post=8128"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/wp-json\/wp\/v2\/ppma_author?post=8128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}