{"id":2368,"date":"2014-01-31T00:00:00","date_gmt":"2014-01-30T23:00:00","guid":{"rendered":"https:\/\/www.softeng.es\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/"},"modified":"2024-11-12T16:02:10","modified_gmt":"2024-11-12T15:02:10","slug":"power-bi-consultation-and-transforms-your-data-with-power-query","status":"publish","type":"post","link":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/","title":{"rendered":"Power BI: Consultation and transforms your data with Power Query"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_wp_text el_class=&#8217;section-post-default&#8217;]<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" width=\"534\" height=\"227\" alt=\"Power Query\" src=\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f\"><\/p>\n<p><strong>Power<\/strong> Tool <strong>BI Business Intelligence<\/strong> (BI) incorporating productivity suite <strong>Office 365<\/strong> and allows us to automate the processes of generation of analytical information.<\/p>\n<p><strong>Power BI<\/strong> includes a collection of features that allow you to visualize data, share discovery and participate in new and intuitive ways of collaboration: Power Query, Power Map, Power Pivot and Power View.<\/p>\n<p>This post is the first in a series of articles that discuss each complements BI Power.<\/p>\n<h3>Power Query<\/h3>\n<p>It is one of Excel add-ins provided as part of the Power BI tool, it is an ETL tool (stands for Extract, Transform and Load) integrated into Excel to search, transform and combine data from a variety of sources ( both companies, as public data sources online) and with an intuitive and interactive interface.<\/p>\n<p><img decoding=\"async\" alt=\"Power Query\" src=\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b5f1e261-a2af-4497-a750-4f73efc5e1fe\"><\/p>\n<p><strong>With Power Query Tea<\/strong><\/p>\n<ul>\n<li> Data search and connect through a wide variety of sources. <\/li>\n<li> Online conduct searches of a large collection of public data sources, including tables of Wikipedia, a subset of Windows Azure Marketplace, and a subset of Data.gov <\/li>\n<li> Combine data from several sources and sort for further analysis with tools such as Power Pivot, or for viewing tools such as Power View and Power Map. <\/li>\n<li> Along with Power View functionality, you can share and manage queries created, and search data within your organization. <\/li>\n<\/ul>\n<h4>Data Sources Power Query<\/h4>\n<p>The functionality allows you to enter data into Excel from virtually any type of data sources listed below:<\/p>\n<ul>\n<li> From the web <\/li>\n<li> From a file \u2013 Excel, CSV, XML, text, or a folder that contains files with metadata and links <\/li>\n<li> From a database \u2013 SQL Server, SQL Azure, Access, Oracle, IBM DB2, MySQL, PostgreSQL, Sybase and Teradata <\/li>\n<li> Data from other sources \u2013 List of SharePoint, OData source, Windows Azure Marketplace, Hadoop Distributed File System \u2013 HDFS, Windows Azure Blob storage, Windows Azure Table storage, Active Directory, Exchange and Facebook. <\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>Want to know more about how BI can help Power?<\/p>\n<p>\u00a0<\/p>\n<p>[\/vc_wp_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>[vc_row][vc_column][vc_wp_text el_class=&#8217;section-post-default&#8217;] Power Tool BI Business Intelligence (BI) incorporating productivity suite Office 365 and allows us to automate the processes of generation of analytical information. Power BI includes a collection of features that allow you to visualize data, share discovery and participate in new and intuitive ways of collaboration: Power Query, Power Map, Power Pivot [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[87,1],"tags":[],"categoria_posts":[],"class_list":["post-2368","post","type-post","status-publish","format-standard","hentry","category-modern-work-en","category-sin-categorizar"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Power BI: Consultation and transforms your data with Power Query - Softeng<\/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.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power BI: Consultation and transforms your data with Power Query - Softeng\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_wp_text el_class=&#8217;section-post-default&#8217;] Power Tool BI Business Intelligence (BI) incorporating productivity suite Office 365 and allows us to automate the processes of generation of analytical information. Power BI includes a collection of features that allow you to visualize data, share discovery and participate in new and intuitive ways of collaboration: Power Query, Power Map, Power Pivot [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Softeng\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-30T23:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-12T15:02:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f\" \/>\n<meta name=\"author\" content=\"Daniel Navarro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Navarro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\"},\"author\":{\"name\":\"Daniel Navarro\",\"@id\":\"https:\/\/www.softeng.es\/en\/#\/schema\/person\/ed4f333f0a809c0610c9f7d9f224ff09\"},\"headline\":\"Power BI: Consultation and transforms your data with Power Query\",\"datePublished\":\"2014-01-30T23:00:00+00:00\",\"dateModified\":\"2024-11-12T15:02:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\"},\"wordCount\":337,\"publisher\":{\"@id\":\"https:\/\/www.softeng.es\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f\",\"articleSection\":[\"MODERN WORK\",\"Sin categorizar\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\",\"url\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\",\"name\":\"Power BI: Consultation and transforms your data with Power Query - Softeng\",\"isPartOf\":{\"@id\":\"https:\/\/www.softeng.es\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f\",\"datePublished\":\"2014-01-30T23:00:00+00:00\",\"dateModified\":\"2024-11-12T15:02:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage\",\"url\":\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f\",\"contentUrl\":\"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.softeng.es\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power BI: Consultation and transforms your data with Power Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.softeng.es\/en\/#website\",\"url\":\"https:\/\/www.softeng.es\/en\/\",\"name\":\"Softeng\",\"description\":\"Softeng | Maximize the cloud. Securely.\",\"publisher\":{\"@id\":\"https:\/\/www.softeng.es\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.softeng.es\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.softeng.es\/en\/#organization\",\"name\":\"Softeng\",\"url\":\"https:\/\/www.softeng.es\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.softeng.es\/en\/#\/schema\/logo\/image\/\",\"url\":\"\/wp-content\/uploads\/2024\/11\/Logotipo-para-SEOYoast.png\",\"contentUrl\":\"\/wp-content\/uploads\/2024\/11\/Logotipo-para-SEOYoast.png\",\"width\":696,\"height\":696,\"caption\":\"Softeng\"},\"image\":{\"@id\":\"https:\/\/www.softeng.es\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/softeng\/\",\"https:\/\/www.youtube.com\/@SoftengSL\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.softeng.es\/en\/#\/schema\/person\/ed4f333f0a809c0610c9f7d9f224ff09\",\"name\":\"Daniel Navarro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e85306c4726a5092f25aa17409ba329012330214ef80d60e6e3c7431747af1b1?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e85306c4726a5092f25aa17409ba329012330214ef80d60e6e3c7431747af1b1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e85306c4726a5092f25aa17409ba329012330214ef80d60e6e3c7431747af1b1?s=96&d=mm&r=g\",\"caption\":\"Daniel Navarro\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Power BI: Consultation and transforms your data with Power Query - Softeng","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.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/","og_locale":"en_US","og_type":"article","og_title":"Power BI: Consultation and transforms your data with Power Query - Softeng","og_description":"[vc_row][vc_column][vc_wp_text el_class=&#8217;section-post-default&#8217;] Power Tool BI Business Intelligence (BI) incorporating productivity suite Office 365 and allows us to automate the processes of generation of analytical information. Power BI includes a collection of features that allow you to visualize data, share discovery and participate in new and intuitive ways of collaboration: Power Query, Power Map, Power Pivot [&hellip;]","og_url":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/","og_site_name":"Softeng","article_published_time":"2014-01-30T23:00:00+00:00","article_modified_time":"2024-11-12T15:02:10+00:00","og_image":[{"url":"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f","type":"","width":"","height":""}],"author":"Daniel Navarro","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Daniel Navarro","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#article","isPartOf":{"@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/"},"author":{"name":"Daniel Navarro","@id":"https:\/\/www.softeng.es\/en\/#\/schema\/person\/ed4f333f0a809c0610c9f7d9f224ff09"},"headline":"Power BI: Consultation and transforms your data with Power Query","datePublished":"2014-01-30T23:00:00+00:00","dateModified":"2024-11-12T15:02:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/"},"wordCount":337,"publisher":{"@id":"https:\/\/www.softeng.es\/en\/#organization"},"image":{"@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f","articleSection":["MODERN WORK","Sin categorizar"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/","url":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/","name":"Power BI: Consultation and transforms your data with Power Query - Softeng","isPartOf":{"@id":"https:\/\/www.softeng.es\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage"},"image":{"@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f","datePublished":"2014-01-30T23:00:00+00:00","dateModified":"2024-11-12T15:02:10+00:00","breadcrumb":{"@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#primaryimage","url":"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f","contentUrl":"https:\/\/softeng.blob.core.windows.net\/softengpublish\/invar\/b41384be-13e7-4d9e-98ca-99b05b379e7f"},{"@type":"BreadcrumbList","@id":"https:\/\/www.softeng.es\/en\/blog\/power-bi-consultation-and-transforms-your-data-with-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.softeng.es\/en\/"},{"@type":"ListItem","position":2,"name":"Power BI: Consultation and transforms your data with Power Query"}]},{"@type":"WebSite","@id":"https:\/\/www.softeng.es\/en\/#website","url":"https:\/\/www.softeng.es\/en\/","name":"Softeng","description":"Softeng | Maximize the cloud. Securely.","publisher":{"@id":"https:\/\/www.softeng.es\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.softeng.es\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.softeng.es\/en\/#organization","name":"Softeng","url":"https:\/\/www.softeng.es\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.softeng.es\/en\/#\/schema\/logo\/image\/","url":"\/wp-content\/uploads\/2024\/11\/Logotipo-para-SEOYoast.png","contentUrl":"\/wp-content\/uploads\/2024\/11\/Logotipo-para-SEOYoast.png","width":696,"height":696,"caption":"Softeng"},"image":{"@id":"https:\/\/www.softeng.es\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/softeng\/","https:\/\/www.youtube.com\/@SoftengSL"]},{"@type":"Person","@id":"https:\/\/www.softeng.es\/en\/#\/schema\/person\/ed4f333f0a809c0610c9f7d9f224ff09","name":"Daniel Navarro","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e85306c4726a5092f25aa17409ba329012330214ef80d60e6e3c7431747af1b1?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e85306c4726a5092f25aa17409ba329012330214ef80d60e6e3c7431747af1b1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e85306c4726a5092f25aa17409ba329012330214ef80d60e6e3c7431747af1b1?s=96&d=mm&r=g","caption":"Daniel Navarro"}}]}},"_links":{"self":[{"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/posts\/2368","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/comments?post=2368"}],"version-history":[{"count":1,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/posts\/2368\/revisions"}],"predecessor-version":[{"id":36160,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/posts\/2368\/revisions\/36160"}],"wp:attachment":[{"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/media?parent=2368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/categories?post=2368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/tags?post=2368"},{"taxonomy":"categoria_posts","embeddable":true,"href":"https:\/\/www.softeng.es\/en\/wp-json\/wp\/v2\/categoria_posts?post=2368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}