{"id":3400,"date":"2022-10-31T20:51:55","date_gmt":"2022-10-31T19:51:55","guid":{"rendered":"https:\/\/kalkulacija.com\/wordpress\/?p=3400"},"modified":"2022-10-31T20:56:49","modified_gmt":"2022-10-31T19:56:49","slug":"istorija-power-query","status":"publish","type":"post","link":"https:\/\/kalkulacija.com\/wordpress\/en\/istorija-power-query\/","title":{"rendered":"Why Do We Need Power Query?  &#8211; History of Power Query"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #0d590e;color:#0d590e\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #0d590e;color:#0d590e\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/istorija-power-query\/#Zasto_nam_je_potreban_Power_Query\" >Za\u0161to nam je potreban Power Query?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/istorija-power-query\/#Povezivanje_podataka\" >Povezivanje podataka<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/istorija-power-query\/#Why_do_we_need_Power_Query\" >Why do we need Power Query?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/kalkulacija.com\/wordpress\/en\/istorija-power-query\/#Linking_data\" >Linking data<\/a><\/li><\/ul><\/nav><\/div>\nHistory of Power Query in\u00a0<a href=\"https:\/\/kalkulacija.com\/istorijat-dodavanja-formula-u-excelu\/\">Excel Versions<\/a>:\u00a0 <strong>2010, 2013, 2016, 2019, 2021, 365, for\u00a0<span class=\"appliesToItem\">Mac<\/span>\u00a0\u00a0and for\u00a0\u00a0<span class=\"appliesToItem\">web<\/span><\/strong><\/p>\n<p>Until 2010, there was a clear distinction between small and large data analysis.\u00a0Excel was useful for tables of up to 1 million data, and for more than that you had to use the famous Crystal Report or similar BI system.\u00a0Erasing the boundaries between IT support and business users started with\u00a0<a href=\"https:\/\/kalkulacija.com\/wordpress\/category\/microsoft-excel\/power-excel\/powerpivot\/\">PowerPivot<\/a>, which you can read more about on the pages of this site.<\/p>\n<p>Data was less and less entered into spreadsheets and more and more data was already in databases and various other sources.\u00a0Business users have more and more data and a growing need to analyze that data.\u00a0IT support is becoming a bottleneck in business, which has forced Microsoft to offer additions in the form of PowerPivot and PowerQuery with Office 2010 to download, transform and analyze more than 1 million data.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Why_do_we_need_Power_Query\"><\/span><span id=\"Zasto_nam_je_potreban_Power_Query\" class=\"ez-toc-section\"><\/span><strong>Why do we need Power Query?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Since the worksheet in Excel is limited to 1 million rows (1,048,576 rows), Velocity technology was designed.\u00a0Create Pivot Tables on data stored in SQL Server or other tabular formats such as XML, JSON, CSV, TXT, MDB, PDF, etc.<\/p>\n<p class=\"\"><strong><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/about-power-query-in-excel-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a\">Power Query<\/a><\/strong>\u00a0or in translation<a href=\"https:\/\/kalkulacija.com\/wordpress\/power-query-mocni-upiti\/\">\u00a0Powerful queries<\/a>\u00a0is a technology that allows you not to copy data into excel and burden the working memory, but only to establish a connection with the data source.\u00a0Make the necessary adjustments to the format, select the necessary columns from the table, transform the data form in one word, and only then use them to create a pivot (derived) table as a report form.<\/p>\n<p>This data processing process is called the ETL process (Extract Transform Load) and is necessary in every data processing process.\u00a0The first form of data we receive from a source is not in such a state that it can be immediately analyzed.\u00a0Microsoft Excel went a step further and supplemented the data preparation process with another set of activities, which is combining data, as you can see in the following illustration.<\/p>\n<p class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png\" alt=\"Istorija Power Query\" width=\"508\" height=\"173\" \/><\/p>\n<p class=\"wp-caption alignnone\">History of Power Query<\/p>\n<p>In addition to Excel users, there is another category of people who dedicate their professional lives to data analysis: business intelligence (BI) professionals.\u00a0BI is the science of gaining insights from large amounts of information, and in recent years, BI professionals have learned and created many new techniques and tools to manage systems that can handle volumes of hundreds of millions or even billions of rows.\u00a0BI systems require the effort of many professionals and expensive hardware to run.\u00a0They are powerful, but expensive and slow to build, which is a serious drawback.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Linking_data\"><\/span><span id=\"Povezivanje_podataka\" class=\"ez-toc-section\"><\/span>Linking data<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To connect the data, we must select the Data tab.<\/p>\n<figure class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-3415 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/10\/Povezivanje-podataka.png\" sizes=\"auto, (max-width: 279px) 100vw, 279px\" srcset=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/10\/Povezivanje-podataka.png 279w, https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/10\/Povezivanje-podataka-271x300.png 271w\" alt=\"Linking data\" width=\"279\" height=\"309\" \/><figcaption class=\"wp-caption-text\">Linking data<\/figcaption><\/figure>\n<p>Importing data using\u00a0\u00a0<strong>Power Query<\/strong>\u00a0is easy.\u00a0Excel provides many common data transfer links that can be accessed from the\u00a0<strong>Data<\/strong>\u00a0tab \u00a0and found from the\u00a0\u00a0<strong>Get Data command.<\/strong><\/p>\n<ul>\n<li>Download data from\u00a0\u00a0<strong>a single file<\/strong>\u00a0such as an Excel workbook, text or CSV file, XML and JSON files.\u00a0You can also import multiple files from a given folder.<\/li>\n<li>Download data from\u00a0\u00a0<strong>various databases<\/strong>\u00a0such as SQL Server, Microsoft Access, Analysis Services, SQL Server Analysis Server, Oracle, IBM DB2, MiSQL, PostgreSQL, Sybase, Teradata and SAP HANA databases.<\/li>\n<li>Download data from\u00a0\u00a0<strong>Microsoft Azure<\/strong><\/li>\n<li>Get data from\u00a0\u00a0<strong>online services<\/strong>\u00a0like Sharepoint, Microsoft Exchange, Dynamics 365, Facebook and Salesforce.<\/li>\n<li>Retrieve data from\u00a0\u00a0<strong>other sources<\/strong>\u00a0\u00a0such as a table or scope within the current workbook, from the web, Microsoft Query, Hadoop, OData feed, ODBC, and OLEDB.<\/li>\n<li>We can\u00a0\u00a0<strong>join two queries<\/strong>\u00a0similar to joining two queries in SQL.<\/li>\n<li>We can\u00a0\u00a0<strong>add a query to another query<\/strong>\u00a0similar to joining two queries in SQL.<\/li>\n<\/ul>\n<p><strong>Note<\/strong>\u00a0\u00a0: Available data connection options will depend on your version of Excel.<\/p>\n<p>There are several common query types available at the top level of the ribbon commands found in the\u00a0\u00a0<strong>Get &amp; Transform section of the\u00a0<\/strong><strong>Data<\/strong>\u00a0\u00a0tab\u00a0\u00a0.\u00a0From here we can easily access\u00a0\u00a0<strong>From Text\/CSV<\/strong>\u00a0,\u00a0\u00a0<strong>From Web<\/strong>\u00a0\u00a0and\u00a0\u00a0<strong>From Table\/Range queries.\u00a0<\/strong>They are just duplicated outside of the\u00a0\u00a0<strong>Get Data<\/strong>\u00a0command \u00a0for ease of use, as you will probably use them more often.<\/p>\n<p><span class=\"goog-text-highlight\">Depending on which type of data connection you choose, Excel will guide you through setting up the connection, and there may be several options to choose from during the process.<\/span>\n\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-right kksr-valign-bottom\"\n    data-payload='{&quot;align&quot;:&quot;right&quot;,&quot;id&quot;:&quot;3400&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;bottom&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;Why Do We Need Power Query?  - History of Power Query&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (3 votes)    <\/div>\n    <\/div>","protected":false},"excerpt":{"rendered":"<p>History of Power Query in\u00a0Excel Versions:\u00a0 2010, 2013, 2016, 2019, 2021, 365, for\u00a0Mac\u00a0\u00a0and for\u00a0\u00a0web Until 2010, there was a clear<\/p>\n","protected":false},"author":1,"featured_media":818,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,40],"tags":[],"class_list":["post-3400","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-excel","category-powerquery"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Istorija Power Query<\/title>\n<meta name=\"description\" content=\"Istorija Power Query alata koji nam omogu\u0107ava konekciju i transformaciju podataka iz razli\u010ditih izvora.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Istorija Power Query\" \/>\n<meta property=\"og:description\" content=\"Istorija Power Query alata koji nam omogu\u0107ava konekciju i transformaciju podataka iz razli\u010ditih izvora.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Calculation in essence of everything!\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-31T19:51:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-31T19:56:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"508\" \/>\n\t<meta property=\"og:image:height\" content=\"173\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"headline\":\"Why Do We Need Power Query? &#8211; History of Power Query\",\"datePublished\":\"2022-10-31T19:51:55+00:00\",\"dateModified\":\"2022-10-31T19:56:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/\"},\"wordCount\":1459,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/powerq1.png\",\"articleSection\":[\"Power Excel\",\"\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/\",\"name\":\"Istorija Power Query\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/powerq1.png\",\"datePublished\":\"2022-10-31T19:51:55+00:00\",\"dateModified\":\"2022-10-31T19:56:49+00:00\",\"description\":\"Istorija Power Query alata koji nam omogu\u0107ava konekciju i transformaciju podataka iz razli\u010ditih izvora.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#primaryimage\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/powerq1.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2017\\\/09\\\/powerq1.png\",\"width\":508,\"height\":173,\"caption\":\"Power Query\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/istorija-power-query\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Istorija Power Query &#8211; Za\u0161to nam je potreban Power Query?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#website\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/\",\"name\":\"Calculation in essence of everything!\",\"description\":\"Go ahead! Improve your data processing skills!\",\"publisher\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/#\\\/schema\\\/person\\\/f5e8a5fd4f5351b191abce4d2eb18ee4\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"url\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"contentUrl\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\",\"width\":128,\"height\":128,\"caption\":\"admin\"},\"logo\":{\"@id\":\"https:\\\/\\\/kalkulacija.com\\\/wordpress\\\/wp-content\\\/uploads\\\/2020\\\/05\\\/Excel-icon.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Istorija Power Query","description":"Istorija Power Query alata koji nam omogu\u0107ava konekciju i transformaciju podataka iz razli\u010ditih izvora.","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:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/","og_locale":"en_US","og_type":"article","og_title":"Istorija Power Query","og_description":"Istorija Power Query alata koji nam omogu\u0107ava konekciju i transformaciju podataka iz razli\u010ditih izvora.","og_url":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/","og_site_name":"Calculation in essence of everything!","article_published_time":"2022-10-31T19:51:55+00:00","article_modified_time":"2022-10-31T19:56:49+00:00","og_image":[{"width":508,"height":173,"url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#article","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/"},"author":{"name":"admin","@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"headline":"Why Do We Need Power Query? &#8211; History of Power Query","datePublished":"2022-10-31T19:51:55+00:00","dateModified":"2022-10-31T19:56:49+00:00","mainEntityOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/"},"wordCount":1459,"commentCount":0,"publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png","articleSection":["Power Excel",""],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/","url":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/","name":"Istorija Power Query","isPartOf":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#website"},"primaryImageOfPage":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#primaryimage"},"image":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png","datePublished":"2022-10-31T19:51:55+00:00","dateModified":"2022-10-31T19:56:49+00:00","description":"Istorija Power Query alata koji nam omogu\u0107ava konekciju i transformaciju podataka iz razli\u010ditih izvora.","breadcrumb":{"@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#primaryimage","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png","width":508,"height":173,"caption":"Power Query"},{"@type":"BreadcrumbList","@id":"https:\/\/kalkulacija.com\/wordpress\/istorija-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kalkulacija.com\/wordpress\/"},{"@type":"ListItem","position":2,"name":"Istorija Power Query &#8211; Za\u0161to nam je potreban Power Query?"}]},{"@type":"WebSite","@id":"https:\/\/kalkulacija.com\/wordpress\/#website","url":"https:\/\/kalkulacija.com\/wordpress\/","name":"Calculation in essence of everything!","description":"Go ahead! Improve your data processing skills!","publisher":{"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kalkulacija.com\/wordpress\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/kalkulacija.com\/wordpress\/#\/schema\/person\/f5e8a5fd4f5351b191abce4d2eb18ee4","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","url":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","contentUrl":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png","width":128,"height":128,"caption":"admin"},"logo":{"@id":"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2020\/05\/Excel-icon.png"}}]}},"_links":{"self":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/comments?post=3400"}],"version-history":[{"count":19,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3400\/revisions"}],"predecessor-version":[{"id":3420,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/posts\/3400\/revisions\/3420"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media\/818"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/media?parent=3400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/categories?post=3400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/en\/wp-json\/wp\/v2\/tags?post=3400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}