{"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\/istorija-power-query\/","title":{"rendered":"[:sr]Istorija Power Query &#8211; Za\u0161to nam je potreban Power Query? [:en]Why Do We Need Power Query?  &#8211; History of Power Query[:]"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 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\">[:sr]Sadr\u017eaj[:en] 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\/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\/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\/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\/istorija-power-query\/#Linking_data\" >Linking data<\/a><\/li><\/ul><\/nav><\/div>\n[:sr]Istorija Power Query u <a href=\"https:\/\/kalkulacija.com\/istorijat-dodavanja-formula-u-excelu\/\">Ekcel Verzijama<\/a>:\u00a0<strong>2010, 2013, 2016, 2019, 2021, 365, za <span class=\"appliesToItem\">Mac<\/span>\u00a0i za\u00a0<span class=\"appliesToItem\">veb<\/span><\/strong><\/p>\n<p>Do 2010. godine postojala je jasna razlika izme\u0111u analize male i velike koli\u010dine podataka. Ekcel je bio koristan za tabele do 1 milion podataka, a za vi\u0161e od toga morali ste koristiti \u010duveni Crystal Report ili sli\u010dan BI sistem. Brisanjem granica izme\u0111u IT podr\u0161ke i poslovnih korisnika po\u010delo je <a href=\"https:\/\/kalkulacija.com\/wordpress\/category\/microsoft-excel\/power-excel\/powerpivot\/\">PowerPivot<\/a>-om o kojem mo\u017eete vi\u0161e pro\u010ditati na stranicama ovog sajta.<\/p>\n<p>Podaci su se sve manje unosili u tabele i sve vi\u0161e podataka je ve\u0107 bilo u bazama podataka i raznim drugim izvorima. Poslovni korisnici imaju sve vi\u0161e podataka i sve ve\u0107u potrebu za analiziranjem tih podataka. IT podr\u0161ka postaje usko grlo u poslovanju, \u0161to je nateralo Microsoft da uz Office 2010 ponudi dodatke u vidu PowerPivot-a i PowerQuery za preuzimanje, transformaciju i analizu vi\u0161e od 1 milion podataka.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Zasto_nam_je_potreban_Power_Query\"><\/span><strong style=\"font-size: 1.0625rem;\">Za\u0161to nam je potreban Power Query?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Po\u0161to je radna tabela u Excel-u ograni\u010dena na 1milion redova (1,048,576 redova) osmi\u0161ljena je Velocity tehnologija. Izrade Pivot tabele nad podacima koji se nalaze u SQL serveru ili nekim drugim tabelarnim formatima kao \u0161to su XML, JSON, CSV, TXT, MDB, PDF itd.<\/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> ili u prevodu <a href=\"https:\/\/kalkulacija.com\/wordpress\/power-query-mocni-upiti\/\">Mo\u0107ni upiti<\/a> su tehnologija koja vam omogu\u0107ava da ne kopirate podatke u excel i opteretite radnu memoriju, nego samo da uspostavite konekciju sa izvorom podataka. Izvr\u0161ite potrebna prilago\u0111avanja formata, odaberete potrebne kolone iz tabele jednom re\u010dju transformi\u0161ete formu podataka i tek tada ih upotrebite za izradu pivot (izvedene) tabele kao formu izve\u0161taja.<\/p>\n<p>Ovaj proces obrade podataka se naziva ETL proces (eng. Extract Transform Load \u2013 Izdvoji Transformi\u0161i U\u010ditaj) i neophodan je u svakom procesu obrade podataka. Prvi oblik podataka koji dobijemo iz nekog izvora nije u takvom stanju da se mo\u017ee odmah analizirati. Microsoft Excel je oti\u0161ao korak dalje i dogradio proces pripreme podataka sa jo\u0161 jednim setom aktivnosti, a to je kombinovanje podataka, kao \u0161to mo\u017eete videti na slede\u0107oj ilustraciji.<\/p>\n<figure style=\"width: 508px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2017\/09\/powerq1.png\" alt=\"Istorija Power Query\" width=\"508\" height=\"173\" \/><figcaption class=\"wp-caption-text\">Istorija Power Query<\/figcaption><\/figure>\n<p>Pored korisnika Ekcel-a, postoji jo\u0161 jedna kategorija ljudi koji svoj profesionalni \u017eivot posvec\u0301uju analizi podataka: profesionalci za poslovnu inteligenciju (BI). BI je nauka o dobijanju uvida iz velikih koli\u010dina informacija, a poslednjih godina BI profesionalci su nau\u010dili i kreirali mnoge nove tehnike i alate za upravljanje sistemima koji mogu da obra\u0111uju opseg od stotina miliona ili \u010dak milijardi redova. BI sistemi zahtevaju trud mnogih profesionalaca i skup hardver za pokretanje. Oni su moc\u0301ni, ali su skupi i spori za izgradnju, \u0161to je ozbiljan nedostatak.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Povezivanje_podataka\"><\/span>Povezivanje podataka<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Da bi povezali podatke moramo izabrati tabulator Data.<\/p>\n<figure style=\"width: 279px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-3415 size-full\" src=\"https:\/\/kalkulacija.com\/wordpress\/wp-content\/uploads\/2022\/10\/Povezivanje-podataka.png\" alt=\"Povezivanje podataka\" width=\"279\" height=\"309\" 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\" sizes=\"auto, (max-width: 279px) 100vw, 279px\" \/><figcaption class=\"wp-caption-text\">Povezivanje podataka<\/figcaption><\/figure>\n<p>Uvoz podataka pomo\u0107u\u00a0<strong>Power Query <\/strong>je jednostavan. Excel pru\u017ea mnoge uobi\u010dajene veze za prenos podataka kojima se mo\u017ee pristupiti sa kartice <strong>Data<\/strong>\u00a0i koje se mogu prona\u0107i iz\u00a0komande\u00a0<strong>Get Data.<\/strong><\/p>\n<ul>\n<li>Preuzmite podatke iz\u00a0<strong>jedne datoteke<\/strong> kao \u0161to je Excel radna sveska, tekstualna ili CSV datoteka, XML i JSON datoteke. Tako\u0111e mo\u017eete da uvezete vi\u0161e datoteka iz date fascikle.<\/li>\n<li>Preuzmite podatke iz\u00a0<strong>razli\u010ditih baza podataka<\/strong> kao \u0161to su SQL Server, Microsoft Access, Analysis Services, SQL Server Analysis Server, Oracle, IBM DB2, MiSQL, PostgreSQL, Sybase, Teradata i SAP HANA baze podataka.<\/li>\n<li>Preuzmite podatke od\u00a0<strong>Microsoft Azure<\/strong><\/li>\n<li>Dobijajte podatke sa\u00a0<strong>usluga na mre\u017ei<\/strong> kao \u0161to su Sharepoint, Microsoft Exchange, Dinamics 365, Facebook i Salesforce.<\/li>\n<li>Preuzmite podatke iz\u00a0<strong>drugih izvora<\/strong>\u00a0kao \u0161to su tabela ili opseg unutar trenutne radne sveske, sa veba, Microsoft Kueri-a, Hadoop-a, OData fida, ODBC-a i OLEDB-a.<\/li>\n<li>Mo\u017eemo\u00a0<strong>spojiti dva upita<\/strong> sli\u010dno kao spajanje dva upita u SQL-u.<\/li>\n<li>Mo\u017eemo\u00a0<strong>dodati upit drugom upitu<\/strong> sli\u010dnom spoju dva upita u SQL-u.<\/li>\n<\/ul>\n<p><strong>Napomena<\/strong>\u00a0: Dostupne opcije veze za prenos podataka \u0107e zavisiti od va\u0161e verzije Ekcel-a.<\/p>\n<p>Postoji nekoliko uobi\u010dajenih tipova upita dostupnih na najvi\u0161em nivou komandi trake koje se nalaze u odel\u0458ku\u00a0<strong>Get &amp; Transform<\/strong>\u00a0na kartici\u00a0<strong>Podaci<\/strong>.\u00a0Odavde mo\u017eemo lako pristupiti\u00a0upitima\u00a0<strong>From Text\/CSV<\/strong>,\u00a0<strong>From Veb<\/strong>\u00a0i\u00a0<strong>From Table\/Range. <\/strong>Oni su samo duplirani izvan komande\u00a0<strong>Get Data<\/strong>\u00a0radi lak\u0161eg kori\u0161\u0107enja, jer \u0107ete ih verovatno koristiti \u010de\u0161\u0107e.<\/p>\n<p>U zavisnosti od toga koji tip veze za prenos podataka izaberete, Ekcel \u0107e vas voditi kroz pode\u0161avanje veze i mo\u017eda postoji nekoliko opcija koje mo\u017eete izabrati tokom procesa.[:en]History 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;[:sr] Ocenite [:en]Rate this [:]post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 votes)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;[:sr]Istorija Power Query - Za\u0161to nam je potreban Power Query? [:en]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>\n","protected":false},"excerpt":{"rendered":"<p>[:sr]Istorija Power Query u Ekcel Verzijama:\u00a02010, 2013, 2016, 2019, 2021, 365, za Mac\u00a0i za\u00a0veb Do 2010. godine postojala je jasna<\/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 v28.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=\"Kalkulacija u osnovi svega!\" \/>\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\":\"[:sr]Istorija Power Query &#8211; Za\u0161to nam je potreban Power Query? [:en]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\",\"PowerQuery\"],\"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\":\"Kalkulacija u osnovi svega!\",\"description\":\"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!\",\"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":"Kalkulacija u osnovi svega!","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":"[:sr]Istorija Power Query &#8211; Za\u0161to nam je potreban Power Query? [:en]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","PowerQuery"],"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":"Kalkulacija u osnovi svega!","description":"Samo napred! Unapredite svoje ve\u0161tine obrade podataka!","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\/wp-json\/wp\/v2\/posts\/3400","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/comments?post=3400"}],"version-history":[{"count":19,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3400\/revisions"}],"predecessor-version":[{"id":3420,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/posts\/3400\/revisions\/3420"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media\/818"}],"wp:attachment":[{"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/media?parent=3400"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/categories?post=3400"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kalkulacija.com\/wordpress\/wp-json\/wp\/v2\/tags?post=3400"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}