{"id":946,"date":"2021-06-11T07:00:00","date_gmt":"2021-06-11T04:00:00","guid":{"rendered":"https:\/\/www.dataplatform.gr\/?p=946"},"modified":"2023-03-31T01:33:14","modified_gmt":"2023-03-30T22:33:14","slug":"fortosi-dedomenon-se-microsoft-excel-me-power-query","status":"publish","type":"post","link":"https:\/\/www.dataplatform.gr\/en\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/","title":{"rendered":"How to load data into Microsoft Excel from a database using Power Query"},"content":{"rendered":"<p>The <strong>Microsoft Excel<\/strong> one of her first programs <strong>Microsoft<\/strong> . From its first versions, it had the ability to collaborate with software from other companies.<\/p>\n\n\n\n<p>In this article we will explore how to connect Excel to any <strong>RDBMS<\/strong> and load data into its sheets.<\/p>\n\n\n\n<p>The method we will use is the <strong>Power<\/strong><strong> Query<\/strong> via <strong>ODBC<\/strong>.<\/p>\n\n\n\n<p>For starters we&#039;ll have to make one <strong>ODBC<\/strong><strong> Data<\/strong><strong> Source<\/strong><strong> <\/strong>on Windows.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"349\" height=\"175\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/1-pq.png\" alt=\"\" class=\"wp-image-950\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/1-pq.png 349w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/1-pq-300x150.png 300w\" sizes=\"auto, (max-width: 349px) 100vw, 349px\" \/><figcaption class=\"wp-element-caption\">1<\/figcaption><\/figure>\n\n\n\n<p>User DSN - Add... - We select the Provider we want<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"555\" height=\"417\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/2-pg.png\" alt=\"\" class=\"wp-image-951\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/2-pg.png 555w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/2-pg-300x225.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><figcaption class=\"wp-element-caption\">2<\/figcaption><\/figure>\n\n\n\n<p>We choose a name for ODBC and put the Server details<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"395\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/3-pg.png\" alt=\"\" class=\"wp-image-952\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/3-pg.png 566w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/3-pg-300x209.png 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><figcaption class=\"wp-element-caption\">3<\/figcaption><\/figure>\n\n\n\n<p>Details of the user who will connect to the database.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"566\" height=\"395\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/4-pg.png\" alt=\"\" class=\"wp-image-953\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/4-pg.png 566w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/4-pg-300x209.png 300w\" sizes=\"auto, (max-width: 566px) 100vw, 566px\" \/><figcaption class=\"wp-element-caption\">4<\/figcaption><\/figure>\n\n\n\n<p>In excel now New Query \u2013 From Other Sources \u2013 From ODBC<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"695\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/5-pg.png\" alt=\"\" class=\"wp-image-954\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/5-pg.png 671w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/5-pg-290x300.png 290w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><figcaption class=\"wp-element-caption\">5<\/figcaption><\/figure>\n\n\n\n<p>*It is not necessary to use ODBC. We can choose From Database without using ODBC on the PC, but we will be limited to the RDBMS options currently provided by Excel.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"756\" height=\"541\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-pg.png\" alt=\"\" class=\"wp-image-955\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-pg.png 756w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/6-pg-300x215.png 300w\" sizes=\"auto, (max-width: 756px) 100vw, 756px\" \/><figcaption class=\"wp-element-caption\">6<\/figcaption><\/figure>\n\n\n\n<p>* In case our RDBMS option is not there, we can choose from <em>From other Sources<\/em> The choise <em>ODBC<\/em>.<\/p>\n\n\n\n<p>In the Data source name field we put the name with which we created the ODBC at the beginning. Also in the SQL statement field we can put SQL query for the data we want to load.<\/p>\n\n\n\n<p>** In the case that the DSN box does not exist, we must write the DSN by hand in the Connection String field, e.g. DSN=sql .<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"524\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/7-pg.png\" alt=\"\" class=\"wp-image-956\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/7-pg.png 701w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/7-pg-300x224.png 300w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><figcaption class=\"wp-element-caption\">7<\/figcaption><\/figure>\n\n\n\n<p>Select Database and fill in username \/ password and connect.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"701\" height=\"370\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/8-pg.png\" alt=\"\" class=\"wp-image-957\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/8-pg.png 701w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/8-pg-300x158.png 300w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><figcaption class=\"wp-element-caption\">8<\/figcaption><\/figure>\n\n\n\n<p>Close &amp; Load will load the data.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"261\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-pg.png\" alt=\"\" class=\"wp-image-948\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-pg.png 539w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/9-pg-300x145.png 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><figcaption class=\"wp-element-caption\">9<\/figcaption><\/figure>\n\n\n\n<p>If we need to make any changes to the query for the data being loaded.<\/p>\n\n\n\n<p>Workbook Queries \u2013 right click \u2013 edit \u2013 Advanced Editor<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"688\" height=\"497\" src=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/10-pg.png\" alt=\"\" class=\"wp-image-949\" srcset=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/10-pg.png 688w, https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/10-pg-300x217.png 300w\" sizes=\"auto, (max-width: 688px) 100vw, 688px\" \/><figcaption class=\"wp-element-caption\">10<\/figcaption><\/figure>\n\n\n\n<p>As we can see, the data was loaded on the page (Sheet) with the button <strong>Refresh<\/strong><strong> All<\/strong><strong> <\/strong>we can refresh the data. With his method <strong>Power<\/strong><strong> Query<\/strong> we can have several Workbook Queries on several different pages (Sheets).<\/p>\n\n\n\n<p>Of course we do not forget for security reasons to create users with minimum rights exclusively for this use.<\/p>","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel one of the first Microsoft programs. From its first versions, it had the ability to collaborate with software from other companies. In this article we will explore how to connect Excel to any RDBMS and load data into its sheets. The method we will use is Power [\u2026]<\/p>","protected":false},"author":1,"featured_media":690,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,11,17],"tags":[24,29,43,23,50],"class_list":["post-946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-databases","category-ms-excel","tag-data-analysis","tag-databases","tag-microsoft-excel","tag-microsoft","tag-power-query"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query - DataPlatform.gr<\/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.dataplatform.gr\/en\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query - DataPlatform.gr\" \/>\n<meta property=\"og:description\" content=\"\u03a4\u03bf Microsoft Excel \u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03c0\u03c1\u03bf\u03b3\u03c1\u03ac\u03bc\u03bc\u03b1\u03c4\u03b1 \u03c4\u03b7\u03c2 Microsoft . \u0391\u03c0\u03cc \u03c4\u03b9\u03c2 \u03c0\u03c1\u03ce\u03c4\u03b5\u03c2 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 \u03b5\u03af\u03c7\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b5\u03c1\u03b3\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bc\u03b5 software \u03ac\u03bb\u03bb\u03c9\u03bd \u03b5\u03c4\u03b1\u03b9\u03c1\u03b5\u03b9\u03ce\u03bd. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b5\u03be\u03b5\u03c1\u03b5\u03c5\u03bd\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf Excel \u03bc\u03b5 \u03bf\u03c0\u03bf\u03b9\u03bf\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 RDBMS \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03c6\u03bf\u03c1\u03c4\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03c4\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c4\u03bf\u03c5. \u0397 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf Power [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dataplatform.gr\/en\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"DataPlatform.gr\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dataplatform.gr\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-06-11T04:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-30T22:33:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_databases_excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Stratos Matzouranis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Stratos Matzouranis\" \/>\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.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/\"},\"author\":{\"name\":\"Stratos Matzouranis\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\"},\"headline\":\"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query\",\"datePublished\":\"2021-06-11T04:00:00+00:00\",\"dateModified\":\"2023-03-30T22:33:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/\"},\"wordCount\":87,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_databases_excel.png\",\"keywords\":[\"Data Analysis\",\"Databases\",\"Excel\",\"Microsoft\",\"Power Query\"],\"articleSection\":[\"Business Intelligence\",\"Databases\",\"Microsoft Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/\",\"name\":\"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query - DataPlatform.gr\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_databases_excel.png\",\"datePublished\":\"2021-06-11T04:00:00+00:00\",\"dateModified\":\"2023-03-30T22:33:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_databases_excel.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_databases_excel.png\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/fortosi-dedomenon-se-microsoft-excel-me-power-query\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Business Intelligence\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/business-intelligence\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Microsoft Excel\",\"item\":\"https:\\\/\\\/www.dataplatform.gr\\\/category\\\/business-intelligence\\\/ms-excel\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#website\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"name\":\"dataplatform.gr - Sky is not the limit!\",\"description\":\"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dataplatform.gr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#organization\",\"name\":\"dataplatform.gr\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"contentUrl\":\"https:\\\/\\\/www.dataplatform.gr\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/dp_logo_wbacki.png\",\"width\":322,\"height\":139,\"caption\":\"dataplatform.gr\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dataplatform.gr\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dataplatform-gr\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dataplatform.gr\\\/#\\\/schema\\\/person\\\/e87bf4fd02b65cb6aa0942f87245bbaf\",\"name\":\"Stratos Matzouranis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g\",\"caption\":\"Stratos Matzouranis\"},\"sameAs\":[\"https:\\\/\\\/www.dataplatform.gr\"],\"url\":\"https:\\\/\\\/www.dataplatform.gr\\\/en\\\/author\\\/stratos-matzouranis\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query - DataPlatform.gr","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.dataplatform.gr\/en\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/","og_locale":"en_US","og_type":"article","og_title":"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query - DataPlatform.gr","og_description":"\u03a4\u03bf Microsoft Excel \u03ad\u03bd\u03b1 \u03b1\u03c0\u03cc \u03c4\u03b1 \u03c0\u03c1\u03ce\u03c4\u03b1 \u03c0\u03c1\u03bf\u03b3\u03c1\u03ac\u03bc\u03bc\u03b1\u03c4\u03b1 \u03c4\u03b7\u03c2 Microsoft . \u0391\u03c0\u03cc \u03c4\u03b9\u03c2 \u03c0\u03c1\u03ce\u03c4\u03b5\u03c2 \u03b5\u03ba\u03b4\u03cc\u03c3\u03b5\u03b9\u03c2 \u03c4\u03bf\u03c5 \u03b5\u03af\u03c7\u03b5 \u03c4\u03b7 \u03b4\u03c5\u03bd\u03b1\u03c4\u03cc\u03c4\u03b7\u03c4\u03b1 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b5\u03c1\u03b3\u03ac\u03b6\u03b5\u03c4\u03b1\u03b9 \u03bc\u03b5 software \u03ac\u03bb\u03bb\u03c9\u03bd \u03b5\u03c4\u03b1\u03b9\u03c1\u03b5\u03b9\u03ce\u03bd. \u03a3\u03b5 \u03b1\u03c5\u03c4\u03cc \u03c4\u03bf \u03ac\u03c1\u03b8\u03c1\u03bf \u03b8\u03b1 \u03b5\u03be\u03b5\u03c1\u03b5\u03c5\u03bd\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c0\u03c9\u03c2 \u03b3\u03af\u03bd\u03b5\u03c4\u03b1\u03b9 \u03bd\u03b1 \u03c3\u03c5\u03bd\u03b4\u03ad\u03c3\u03bf\u03c5\u03bc\u03b5 \u03c4\u03bf Excel \u03bc\u03b5 \u03bf\u03c0\u03bf\u03b9\u03bf\u03b4\u03ae\u03c0\u03bf\u03c4\u03b5 RDBMS \u03ba\u03b1\u03b9 \u03bd\u03b1 \u03c6\u03bf\u03c1\u03c4\u03ce\u03c3\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03c4\u03b1 \u03c6\u03cd\u03bb\u03bb\u03b1 \u03c4\u03bf\u03c5. \u0397 \u03bc\u03ad\u03b8\u03bf\u03b4\u03bf \u03c0\u03bf\u03c5 \u03b8\u03b1 \u03c7\u03c1\u03b7\u03c3\u03b9\u03bc\u03bf\u03c0\u03bf\u03b9\u03ae\u03c3\u03bf\u03c5\u03bc\u03b5 \u03b5\u03af\u03bd\u03b1\u03b9 \u03c4\u03bf Power [&hellip;]","og_url":"https:\/\/www.dataplatform.gr\/en\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/","og_site_name":"DataPlatform.gr","article_publisher":"https:\/\/www.facebook.com\/dataplatform.gr\/","article_published_time":"2021-06-11T04:00:00+00:00","article_modified_time":"2023-03-30T22:33:14+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_databases_excel.png","type":"image\/png"}],"author":"Stratos Matzouranis","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Stratos Matzouranis","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#article","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/"},"author":{"name":"Stratos Matzouranis","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf"},"headline":"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query","datePublished":"2021-06-11T04:00:00+00:00","dateModified":"2023-03-30T22:33:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/"},"wordCount":87,"commentCount":0,"publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"image":{"@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_databases_excel.png","keywords":["Data Analysis","Databases","Excel","Microsoft","Power Query"],"articleSection":["Business Intelligence","Databases","Microsoft Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/","url":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/","name":"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query - DataPlatform.gr","isPartOf":{"@id":"https:\/\/www.dataplatform.gr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#primaryimage"},"image":{"@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_databases_excel.png","datePublished":"2021-06-11T04:00:00+00:00","dateModified":"2023-03-30T22:33:14+00:00","breadcrumb":{"@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#primaryimage","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_databases_excel.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_databases_excel.png","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/www.dataplatform.gr\/fortosi-dedomenon-se-microsoft-excel-me-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u0391\u03c1\u03c7\u03b9\u03ba\u03ae","item":"https:\/\/www.dataplatform.gr\/"},{"@type":"ListItem","position":2,"name":"Business Intelligence","item":"https:\/\/www.dataplatform.gr\/category\/business-intelligence\/"},{"@type":"ListItem","position":3,"name":"Microsoft Excel","item":"https:\/\/www.dataplatform.gr\/category\/business-intelligence\/ms-excel\/"},{"@type":"ListItem","position":4,"name":"\u03a0\u03ce\u03c2 \u03c6\u03bf\u03c1\u03c4\u03ce\u03bd\u03bf\u03c5\u03bc\u03b5 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03c3\u03b5 Microsoft Excel \u03b1\u03c0\u03cc \u03bc\u03af\u03b1 \u03b2\u03ac\u03c3\u03b7 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd \u03bc\u03b5 \u03c7\u03c1\u03ae\u03c3\u03b7 Power Query"}]},{"@type":"WebSite","@id":"https:\/\/www.dataplatform.gr\/#website","url":"https:\/\/www.dataplatform.gr\/","name":"dataplatform.gr - Sky is not the limit!","description":"\u0398\u03b5\u03c9\u03c1\u03af\u03b1, \u03bf\u03b4\u03b7\u03b3\u03bf\u03af \u03ba\u03b1\u03b9 \u03c3\u03ba\u03ad\u03c8\u03b5\u03b9\u03c2 \u03b3\u03b9\u03b1 \u03bd\u03b1 \u03ba\u03ac\u03bd\u03b5\u03c4\u03b5 \u03c4\u03b7 \u03b4\u03bf\u03c5\u03bb\u03b5\u03b9\u03ac \u03c3\u03b1\u03c2 \u03c0\u03b9\u03bf \u03c0\u03b1\u03c1\u03b1\u03b3\u03c9\u03b3\u03b9\u03ba\u03ac \u03ba\u03b1\u03b9 \u03c0\u03b9\u03bf \u03b5\u03cd\u03ba\u03bf\u03bb\u03b1 \u03c0\u03ac\u03bd\u03c9 \u03c3\u03c4\u03b9\u03c2 \u03b2\u03ac\u03c3\u03b5\u03b9\u03c2 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03c9\u03bd, \u03c3\u03c4\u03b7\u03bd SQL, \u03c3\u03c4\u03bf Business Intelligence \u03ba\u03b1\u03b9 \u03c3\u03c4\u03b1 \u03b4\u03b5\u03b4\u03bf\u03bc\u03ad\u03bd\u03b1 \u03b3\u03b5\u03bd\u03b9\u03ba\u03cc\u03c4\u03b5\u03c1\u03b1.","publisher":{"@id":"https:\/\/www.dataplatform.gr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dataplatform.gr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dataplatform.gr\/#organization","name":"dataplatform.gr","url":"https:\/\/www.dataplatform.gr\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/","url":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","contentUrl":"https:\/\/www.dataplatform.gr\/wp-content\/uploads\/2020\/06\/dp_logo_wbacki.png","width":322,"height":139,"caption":"dataplatform.gr"},"image":{"@id":"https:\/\/www.dataplatform.gr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dataplatform.gr\/","https:\/\/www.linkedin.com\/company\/dataplatform-gr\/"]},{"@type":"Person","@id":"https:\/\/www.dataplatform.gr\/#\/schema\/person\/e87bf4fd02b65cb6aa0942f87245bbaf","name":"Stratos Matzouranis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ab973bc4bd1673c43d45de5633a624d9ad13c06902dfdd5a6e3fd9885903865e?s=96&d=mm&r=g","caption":"Stratos Matzouranis"},"sameAs":["https:\/\/www.dataplatform.gr"],"url":"https:\/\/www.dataplatform.gr\/en\/author\/stratos-matzouranis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/comments?post=946"}],"version-history":[{"count":1,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/946\/revisions"}],"predecessor-version":[{"id":5422,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/posts\/946\/revisions\/5422"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media\/690"}],"wp:attachment":[{"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/media?parent=946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/categories?post=946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dataplatform.gr\/en\/wp-json\/wp\/v2\/tags?post=946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}