{"id":2103,"date":"2016-03-11T00:49:09","date_gmt":"2016-03-11T00:49:09","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=2103"},"modified":"2023-10-08T22:48:57","modified_gmt":"2023-10-09T05:48:57","slug":"powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/","title":{"rendered":"PowerBI \ubc0f CouchBase Server 4 - N1QL REST API\ub97c \ud1b5\ud55c \uae30\ubcf8 \uc5f0\uacb0\ub85c JSON \ub370\uc774\ud130\ub97c \ud1b5\ud55c \ubcf4\uace0"},"content":{"rendered":"<h2>PowerBI \ubc0f \ub124\uc774\ud2f0\ube0c JSON \ucc98\ub9ac<\/h2>\n<table border=\"0\" width=\"1072\" cellspacing=\"1\" cellpadding=\"1\">\n<tbody>\n<tr>\n<td style=\"width: 862px\">PowerBI\ub294 \ub370\uc774\ud130\ub97c \uc2dc\uac01\ud654\ud558\ub294 \ub370 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ud6cc\ub96d\ud55c \uc0c8 \ubcf4\uace0 \ud658\uacbd \uc911 \ud558\ub098\uc785\ub2c8\ub2e4. PowerBI\uc758 \uac00\uc7a5 \ud070 \uc7a5\uc810\uc740 \uae30\ubcf8 JSON \uc9c0\uc6d0\uacfc \ub0b4\uc7a5\ub41c \ud504\ub85c\uadf8\ub798\ubc0d \uac00\ub2a5\ud55c \ubcc0\ud658 \uc5d4\uc9c4\uc785\ub2c8\ub2e4. PowerBI\ub294 Couchbase Server\uc640 \uc9c1\uc811 \ub300\ud654\ud558\uc5ec \ub370\uc774\ud130\ub97c \ubcf4\uace0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>ODBC \ub610\ub294 JDBC \ub4dc\ub77c\uc774\ubc84\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4!<\/strong><\/td>\n<td style=\"width: 360px\"><strong><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/th.jpg\" width=\"172\" height=\"84\" \/><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>4\ub2e8\uacc4\ub85c Couchbase Server v4\uc5d0\uc11c \ub370\uc774\ud130 \uc2dc\uac01\ud654\ud558\uae30<\/h2>\n<p>PowerBI\uc5d0\uc11c Couchbase Server \ub370\uc774\ud130\ub97c \uc2dc\uac01\ud654\ud558\ub294 4\ub2e8\uacc4\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/p>\n<h3><strong>#1 \uc0d8\ud50c \ub370\uc774\ud130\ub97c \uac00\uc838\uc635\ub2c8\ub2e4:<\/strong><\/h3>\n<p>Couchbase Server 4\uc640 \ud568\uaed8 \uc81c\uacf5\ub418\ub294 \uc5ec\ud589 \uc0d8\ud50c \ubc84\ud0b7\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uad00\ub9ac\uc790 \ucf58\uc194\uc758 \"\uc124\uc815\" \ud0ed\uc744 \uc0ac\uc6a9\ud558\uac70\ub098 \uc124\uce58 \uc911\uc5d0 \uc774 \ub370\uc774\ud130 \uc9d1\ud569\uc744 \uc124\uce58\ud569\ub2c8\ub2e4. \uc608\uc81c\uc640 \ud568\uaed8 \ub530\ub77c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<h3><strong>#2 N1QL REST API\ub97c \ud1b5\ud574 \ucffc\ub9ac\ud569\ub2c8\ub2e4: <\/strong><\/h3>\n<p>\uc0d8\ud50c\ub85c \ub9e4\uc6b0 \uac04\ub2e8\ud55c \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4: \uc774 \ucffc\ub9ac\ub294 \uac01 \ubaa9\uc801\uc9c0 \uacf5\ud56d\uc73c\ub85c \uac00\ub294 \ucd1d \ud56d\uacf5\ud3b8\uc774 \ud3ec\ud568\ub41c \ubaa8\ub4e0 \ud56d\uacf5\uc0ac\uc758 \uc804\uccb4 \ubaa9\ub85d\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4.<\/p>\n<pre><code class=\"language-sql\">  SELECT a.name, r.destinationairport, count(a.name) as total_flights \r\n  FROM `travel-sample` r JOIN `travel-sample` a ON KEYS r.airlineid \r\n  WHERE r.type =\"route\" AND a.type=\"airline\" \r\n  GROUP BY r.destinationairport, a.name \r\n  ORDER BY r.destinationairport<\/code><\/pre>\n<p>PowerBI\ub97c \ub2e4\uc74c\uacfc \uc5f0\uacb0\ud558\ub824\uba74 <a href=\"https:\/\/www.couchbase.com\/blog\/ko\/products\/n1ql\/\">N1QL<\/a>. \ucffc\ub9ac\ub97c \uc2e4\ud589\ud558\uae30 \uc704\ud574 N1QL REST API\ub97c \uc0ac\uc6a9\ud558\uaca0\uc2b5\ub2c8\ub2e4. \uc798 \ubaa8\ub974\uc2dc\ub294 \ubd84\ub4e4\ub3c4 \uacc4\uc2dc\uaca0\uc9c0\ub9cc N1QL\uc5d0\ub294 \uc560\ub4dc\ud639 \ubb38\uc744 \ubc1b\ub294 REST API\uac00 \ud568\uaed8 \uc81c\uacf5\ub429\ub2c8\ub2e4. N1QL REST API\ub294 \ubb38\uc11c\ud654\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/developer.couchbase.com\/documentation\/server\/4.0\/n1ql\/n1ql-rest-api\/index.html\">\uc5ec\uae30<\/a> \ub85c \uc124\uc815\ud558\uba74 \uc6d0\ud558\ub294 JSON \uc778\uc2dd \ub3c4\uad6c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774 API\ub97c \uc9c1\uc811 \ud638\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc81c\uac00 \uc120\ud0dd\ud55c \ub3c4\uad6c\ub294 <a href=\"https:\/\/www.getpostman.com\/\">\uc6b0\ud3b8 \ubc30\ub2ec\uc6d0<\/a> (\ud06c\ub86c \ub9c8\ucf13\ud50c\ub808\uc774\uc2a4\uc5d0\uc11c\ub3c4 \uc0ac\uc6a9 \uac00\ub2a5). \ud3ec\uc2a4\ud2b8\ub9e8\uacfc \uacb0\ud569\ub41c N1QL REST API\ub294 \uc720\uc120\uc744 \ud1b5\ud574 \uc804\uc1a1\ub418\ub294 \ub0b4\uc6a9\uc744 \uc644\ubcbd\ud558\uac8c \ud30c\uc545\ud560 \uc218 \uc788\uac8c \ud574\uc90d\ub2c8\ub2e4.<\/p>\n<p>\ub2e4\uc74c \uadf8\ub9bc\uc5d0\uc11c\ub294 \uc704\uc758 \ucffc\ub9ac\ub85c \ud3ec\ud2b8 8093\uc758 \ub85c\uceec \ud074\ub7ec\uc2a4\ud130 \ub178\ub4dc\uc5d0 postman\uc73c\ub85c \uc811\uc18d\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/postman_tool.jpg\" width=\"950\" height=\"344\" \/><\/p>\n<p>\uc778\ucf54\ub529\ub41c URL\uc744 Power BI\uc5d0 \uc804\ub2ec\ud558\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \ud45c\uc2dc\ub429\ub2c8\ub2e4:<\/p>\n<pre><code class=\"language-sql\">https:\/\/10.0.0.52:8093\/query\/service?statement=select%20a.name,r.destinationairport,%20count(a.name)%20total_flights%20from%20`travel-sample`%20r%20join%20`travel-sample`%20a%20on%20keys%20r.airlineid%20where%20r.type%20=%22route%22%20and%20a.type=%22airline%22%20group%20by%20r.destinationairport,%20a.name%20order%20by%20r.destinationairport<\/code><\/pre>\n<p><strong>#3 PowerBI\uc5d0\uc11c \ub370\uc774\ud130 \uc81c\ucd9c \ubc0f \ubcc0\ud658: <\/strong><\/p>\n<p>\ub9c8\uc9c0\ub9c9\uc73c\ub85c \ub370\uc2a4\ud06c\ud1b1 \ubc84\uc804\uc758 Power BI\ub97c \uc2e4\ud589\ud574\uc57c \ud569\ub2c8\ub2e4. \ub370\uc2a4\ud06c\ud1b1 \ubc84\uc804\uc740 \ubb34\ub8cc\uc774\uba70 \ub2e4\uc74c\uc5d0\uc11c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/powerbi.microsoft.com\/en-us\/desktop\">\uc5ec\uae30<\/a>.<\/p>\n<ul>\n<li>\"\ub370\uc774\ud130 \uac00\uc838\uc624\uae30\" \uba54\ub274\ub85c \uc774\ub3d9\ud558\uc5ec \ubc29\ubc95\uc73c\ub85c \"\uc6f9\"\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4. \uc704\uc758 URL\uc744 \uc785\ub825\ud558\uace0 \ub370\uc774\ud130\uac00 \ud45c\uc2dc\ub420 \ub54c\uae4c\uc9c0 \uae30\ub2e4\ub9bd\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/powerbi-1-import.jpg\" width=\"480\" height=\"172\" \/><\/p>\n<ul>\n<li>\uc774\uc81c \uc77c\ub828\uc758 \ubcc0\ud658\uc744 \ud1b5\ud574 \ub370\uc774\ud130\ub97c \uc2dc\uac01\ud654\ud560 \uc218 \uc788\ub3c4\ub85d \uc900\ube44\ud558\uaca0\uc2b5\ub2c8\ub2e4.\n<ol>\n<li>\uacb0\uacfc\uac00 Power BI\ub85c \uc2a4\ud2b8\ub9ac\ubc0d\ub418\uba74 N1QL\uc5d0\uc11c \ubc18\ud658\ub418\ub294 JSON \uc18d\uc131\uc744 \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud654\uba74\uc5d0\uc11c '\ubaa9\ub85d' \ub9c1\ud06c\ub97c \ud074\ub9ad\ud558\uc5ec '\uacb0\uacfc'\ub97c \ub4dc\ub9b4\ub2e4\uc6b4\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/powerbi-2-results.jpg\" width=\"950\" height=\"257\" \/><\/p>\n<ol style=\"margin-left: 40px\" start=\"2\">\n<li>\ud14c\uc774\ube14 \ud2b8\ub79c\uc2a4\ud3fc\uc744 \uc0ac\uc6a9\ud574 JSON\uc758 \ubaa8\uc591\uc744 \ub9cc\ub4e4\uaca0\uc2b5\ub2c8\ub2e4. \uc0c1\ub2e8\uc758 '\ud14c\uc774\ube14\ub85c' \uba54\ub274\ub97c \ud074\ub9ad\ud558\uace0 \uad6c\ubd84 \uae30\ud638\ub97c \uc9c0\uc815\ud558\uc9c0 \ub9c8\uc138\uc694. \"\ud655\uc778\"\uc744 \ud074\ub9ad\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/powerbi-3-totable.jpg\" width=\"950\" height=\"426\" \/><\/p>\n<ol style=\"margin-left: 40px\" start=\"3\">\n<li>\ub2e4\uc74c\uc73c\ub85c, \ub2e8\uc77c \uc5f4 \uadf8\ub9ac\ub4dc\uc758 \uc5f4 \uc0c1\ub2e8\uc5d0 \uc788\ub294 \uc791\uc740 '\ubd84\ud560' \uc544\uc774\ucf58\uc744 \ud074\ub9ad\ud558\uc5ec JSON\uc758 \uc18d\uc131\uc744 \ud14c\uc774\ube14\uc758 \uac1c\ubcc4 \uc5f4\ub85c \ubd84\ud560\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/powerbi-4.1-split.jpg\" width=\"950\" height=\"322\" \/><\/p>\n<ol style=\"margin-left: 40px\" start=\"4\">\n<li>\ud655\uc778\uc744 \ud074\ub9ad\ud558\uba74 \uc644\ub8cc\ub41c \ub370\uc774\ud130 \ubcc0\ud658\uc758 \ubaa8\uc2b5\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4... \uc67c\ucabd \uc0c1\ub2e8\uc758 '\ub2eb\uae30 \ubc0f \uc801\uc6a9'\uc744 \ud074\ub9ad\ud558\uae30\ub9cc \ud558\uba74 \ub429\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/powerbi-5-closeandvisualize.jpg\" width=\"950\" height=\"306\" \/><\/p>\n<h3><strong>#4 PowerBI\uc5d0\uc11c \ub370\uc774\ud130 \uc2dc\uac01\ud654: <\/strong><\/h3>\n<p>\uc800\ub294 \uac01 \ud56d\uacf5\uc0ac\uc758 \uac00\uc7a5 \uc778\uae30 \uc788\ub294 \ubaa9\uc801\uc9c0\ub97c \ud45c\uc2dc\ud558\ub294 \ub370 TreeMap \ube44\uc8fc\uc5bc\ub9ac\uc81c\uc774\uc158\uc744 \uc990\uaca8 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uadf8\uacf3\uc5d0 \uac00\ub824\uba74,<\/p>\n<ol>\n<li>\"Column1.destinationairport\"\ub97c \uc544\ub798\uc758 <em>\uadf8\ub8f9<\/em><\/li>\n<li>\"Column1.total_flights\"\ub97c \ub2e4\uc74c \uc704\uce58\ub85c \ub4dc\ub798\uadf8\ud569\ub2c8\ub2e4. <em>\uac12.<\/em><\/li>\n<li>\"Column1.name\"\uc744 \ub2e4\uc74c \uc704\uce58\ub85c \ub4dc\ub798\uadf8\ud569\ub2c8\ub2e4. <em>\ud398\uc774\uc9c0 \uc218\uc900 \ud544\ud130 <\/em>\uc744 \ud074\ub9ad\ud558\uace0 \ud544\ub4dc\ub97c \ud655\uc7a5\ud558\uc5ec '\uc5d0\uc5b4 \ud3ec\uc77c'\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\ub610\ud55c total_flights\uc758 \ub370\uc774\ud130 \uc720\ud615\ub3c4 \uc218\uc815\ud569\ub2c8\ub2e4. \uc774\ub97c \uc704\ud574\uc11c\ub294 \ub450 \ubc88\uc758 \ud074\ub9ad\uc774 \ub354 \ud544\uc694\ud569\ub2c8\ub2e4. \uc544\ub798 \uadf8\ub9bc\uc758 \ub179\uc0c9 \ub354\ud558\uae30\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.<\/p>\n<ol>\n<li>total_flights \uc5f4\uc758 \ub370\uc774\ud130 \uc720\ud615\uc744 \"\uc804\uccb4 \uc22b\uc790\"\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/li>\n<li>total_flights\uc758 \uc9d1\uacc4\ub97c \"\ud569\uacc4\"\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4.<\/li>\n<\/ol>\n<p>\uc774\uc81c \ub05d\ub0ac\uc2b5\ub2c8\ub2e4!<\/p>\n<p style=\"text-align: center\"><img loading=\"lazy\" decoding=\"async\" src=\"\/wp-content\/original-assets\/2016\/january\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/powerbi-6-datatypesum.jpg\" width=\"950\" height=\"594\" \/><\/p>\n<p>\ub610\ud55c ODBC\/JDBC\ub97c \uc0ac\uc6a9\ud558\uc5ec Couchbase Server \ub370\uc774\ud130\uc5d0 \uc5f0\uacb0\ud560 \uc218\ub3c4 \uc788\ub2e4\ub294 \uc810\ub3c4 \uc5b8\uae09\ud558\uace0 \uc2f6\uc2b5\ub2c8\ub2e4. \ubb34\ub8cc\ub85c \ub2e4\uc6b4\ub85c\ub4dc\ud560 \uc218 \uc788\ub294 \ub9c1\ud06c\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <a href=\"https:\/\/www.simba.com\/drivers\/couchbase-odbc-jdbc\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84\uc6a9 ODBC \ubc0f JDBC \ub4dc\ub77c\uc774\ubc84.<\/a><\/p>\n<p>\ud558\uc9c0\ub9cc... \uc624\ub298\ub0a0 \uc0dd\uc131\ub418\uace0 \uc800\uc7a5\ub418\ub294 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130\uc758 \ub300\ubd80\ubd84\uc740 JSON\uc73c\ub85c \ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. \ub530\ub77c\uc11c PowerBI\uc640 \uac19\uc740 \uc0c8\ub85c\uc6b4 \ub370\uc774\ud130 \uc2dc\uac01\ud654 \ud50c\ub7ab\ud3fc\uc740 JSON\uc5d0 \ub300\ud55c \uac15\ub825\ud55c \uc9c0\uc6d0\uc744 \ucd94\uac00\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. PowerBI\ub294 ODBC \ub4dc\ub77c\uc774\ubc84 \uc5c6\uc774\ub3c4 \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc11c\ubc84\uc758 \ub370\uc774\ud130\ub85c \ub9e4\uc6b0 \uc27d\uac8c \uc791\uc5c5\ud560 \uc218 \uc788\uac8c \ud574\uc8fc\ub294 \ud6cc\ub96d\ud55c \uae30\ub2a5\uc744 \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/p>\n<p>\ud589\ubcf5\ud55c \ud574\ud0b9.<\/p>\n<p>\uc528\ud55c \ube44\uc774\ucf54\uae00\ub8e8 - \uc81c\ud488 \uad00\ub9ac \uc774\uc0ac<\/p>","protected":false},"excerpt":{"rendered":"<p>PowerBI and Native JSON Processing PowerBI is one of the great new reporting environments you can use to visualize data. One great advantage of PowerBI is its native JSON support and built-in programmable transformation engine. Power-BI can simply directly talk [&hellip;]<\/p>","protected":false},"author":7,"featured_media":13873,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1812],"tags":[],"ppma_author":[8978],"class_list":["post-2103","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-n1ql-query"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.1 (Yoast SEO v26.1.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PowerBI &amp; Couchbase Server 4 - Reporting over JSON Data with native connectivity through N1QL REST API - The Couchbase Blog<\/title>\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\/ko\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PowerBI &amp; Couchbase Server 4 - Reporting over JSON Data with native connectivity through N1QL REST API\" \/>\n<meta property=\"og:description\" content=\"PowerBI and Native JSON Processing PowerBI is one of the great new reporting environments you can use to visualize data. One great advantage of PowerBI is its native JSON support and built-in programmable transformation engine. Power-BI can simply directly talk [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-11T00:49:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-09T05:48:57+00:00\" \/>\n<meta name=\"author\" content=\"Cihan Biyikoglu, Director of Product Management, 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=\"Cihan Biyikoglu, Director of Product Management, Couchbase\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/\"},\"author\":{\"name\":\"Cihan Biyikoglu, Director of Product Management, Couchbase\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3d8c60500ca29254fcdb2f76f29fb088\"},\"headline\":\"PowerBI &amp; Couchbase Server 4 &#8211; Reporting over JSON Data with native connectivity through N1QL REST API\",\"datePublished\":\"2016-03-11T00:49:09+00:00\",\"dateModified\":\"2023-10-09T05:48:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/\"},\"wordCount\":661,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"articleSection\":[\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/\",\"name\":\"PowerBI &amp; Couchbase Server 4 - Reporting over JSON Data with native connectivity through N1QL REST API - The Couchbase Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"datePublished\":\"2016-03-11T00:49:09+00:00\",\"dateModified\":\"2023-10-09T05:48:57+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png\",\"width\":1800,\"height\":630},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PowerBI &amp; Couchbase Server 4 &#8211; Reporting over JSON Data with native connectivity through N1QL REST API\"}]},{\"@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\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@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\/3d8c60500ca29254fcdb2f76f29fb088\",\"name\":\"Cihan Biyikoglu, Director of Product Management, Couchbase\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/a878e65cb37ac2419416d3289816abd5\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g\",\"caption\":\"Cihan Biyikoglu, Director of Product Management, Couchbase\"},\"description\":\"Cihan Biyikoglu is a director of product management at Couchbase, responsible for the Couchbase Server product. Cihan is a big data enthusiast who brings over twenty years of experience to Redis Labs\u2019 product team. Cihan started his career as a C\/C++ developer.\",\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/cihan-biyikoglu\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PowerBI &amp; Couchbase Server 4 - Reporting over JSON Data with native connectivity through N1QL REST API - The Couchbase Blog","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\/ko\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/","og_locale":"ko_KR","og_type":"article","og_title":"PowerBI &amp; Couchbase Server 4 - Reporting over JSON Data with native connectivity through N1QL REST API","og_description":"PowerBI and Native JSON Processing PowerBI is one of the great new reporting environments you can use to visualize data. One great advantage of PowerBI is its native JSON support and built-in programmable transformation engine. Power-BI can simply directly talk [&hellip;]","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/","og_site_name":"The Couchbase Blog","article_published_time":"2016-03-11T00:49:09+00:00","article_modified_time":"2023-10-09T05:48:57+00:00","author":"Cihan Biyikoglu, Director of Product Management, Couchbase","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Cihan Biyikoglu, Director of Product Management, Couchbase","Est. reading time":"5\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/"},"author":{"name":"Cihan Biyikoglu, Director of Product Management, Couchbase","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/3d8c60500ca29254fcdb2f76f29fb088"},"headline":"PowerBI &amp; Couchbase Server 4 &#8211; Reporting over JSON Data with native connectivity through N1QL REST API","datePublished":"2016-03-11T00:49:09+00:00","dateModified":"2023-10-09T05:48:57+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/"},"wordCount":661,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","articleSection":["SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql-reporting-over-json-data-with-native-connectivity-through-n1ql\/","url":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/","name":"PowerBI &amp; Couchbase Server 4 - Reporting over JSON Data with native connectivity through N1QL REST API - The Couchbase Blog","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","datePublished":"2016-03-11T00:49:09+00:00","dateModified":"2023-10-09T05:48:57+00:00","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/11\/couchbase-nosql-dbaas.png","width":1800,"height":630},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/powerbi-and-couchbase-server-4-with-n1ql---reporting-over-json-data-with-native-connectivity-through-n1ql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PowerBI &amp; Couchbase Server 4 &#8211; Reporting over JSON Data with native connectivity through N1QL REST API"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","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":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@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\/3d8c60500ca29254fcdb2f76f29fb088","name":"Cihan Biyikoglu, \uc81c\ud488 \uad00\ub9ac \uc774\uc0ac, Couchbase","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/a878e65cb37ac2419416d3289816abd5","url":"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g","caption":"Cihan Biyikoglu, Director of Product Management, Couchbase"},"description":"Cihan Biyikoglu\ub294 Couchbase\uc758 \uc81c\ud488 \uad00\ub9ac \ub514\ub809\ud130\ub85c, Couchbase Server \uc81c\ud488\uc744 \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 \ube45 \ub370\uc774\ud130 \uc560\ud638\uac00\ub85c\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ud5d8\uc744 Redis Labs\uc758 \uc81c\ud488 \ud300\uc5d0 \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 C\/C++ \uac1c\ubc1c\uc790\ub85c \uacbd\ub825\uc744 \uc2dc\uc791\ud588\uc2b5\ub2c8\ub2e4.","url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/cihan-biyikoglu\/"}]}},"authors":[{"term_id":8978,"user_id":7,"is_guest":0,"slug":"cihan-biyikoglu","display_name":"Cihan Biyikoglu, Director of Product Management, Couchbase","avatar_url":"https:\/\/secure.gravatar.com\/avatar\/3e1ac58dd480dd8a6e93d700a58d329bb81df928061de04395055a45274b8702?s=96&d=mm&r=g","author_category":"","last_name":"Biyikoglu","first_name":"Cihan","job_title":"","user_url":"","description":"Cihan Biyikoglu\ub294 Couchbase\uc758 \uc81c\ud488 \uad00\ub9ac \ub514\ub809\ud130\ub85c, Couchbase Server \uc81c\ud488\uc744 \ub2f4\ub2f9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 \ube45 \ub370\uc774\ud130 \uc560\ud638\uac00\ub85c\uc11c 20\ub144 \uc774\uc0c1\uc758 \uacbd\ud5d8\uc744 Redis Labs\uc758 \uc81c\ud488 \ud300\uc5d0 \uc81c\uacf5\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. Cihan\uc740 C\/C++ \uac1c\ubc1c\uc790\ub85c \uacbd\ub825\uc744 \uc2dc\uc791\ud588\uc2b5\ub2c8\ub2e4."}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=2103"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/2103\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/13873"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=2103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=2103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=2103"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=2103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}