{"id":16253,"date":"2021-05-01T15:01:05","date_gmt":"2021-05-01T09:31:05","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=16253"},"modified":"2021-05-01T15:01:05","modified_gmt":"2021-05-01T09:31:05","slug":"power-query","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/","title":{"rendered":"Introduction To Power Query | Microsoft Azure Power BI Tool"},"content":{"rendered":"<p>This blog post is going to cover all necessary information about Power Query \u2013 one of the important and powerful tools in Microsoft Azure Power BI Service.<\/p>\n<p>Power Query is a powerful Power BI tool that takes care of Power BI operations in locating, connecting, and loading diversified data across various sources. It also shapes and transforms the imported data so that it can be used to create visuals. \u200b<\/p>\n<p>It allows users to build custom data transformation steps and can also save them for future use. Want to know more about Power Query in Microsoft Power BI?<\/p>\n<p>Read the blog post at <em><a class=\"waffle-rich-text-link\" href=\"https:\/\/k21academy.com\/microsoft-azure\/da-100\/power-query\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=da10016_may21\" target=\"_blank\" rel=\"noopener noreferrer\">k21academy.com\/da10016<\/a><\/em> to learn more.<\/p>\n<p>This blog post is going to cover:<\/p>\n<p>\u2022 What Is Power Query?<\/p>\n<p>\u2022 Advantages Of Power Query<\/p>\n<p>\u2022 A Glimpse Of Power Query Editor<\/p>\n<p>\u2022 Importing Data In Power Query Editor<\/p>\n<p>\u2022 The Advanced Editor<\/p>\n<p>\u2022 Working With Power Query Editor<\/p>\n<p>\u2022 Save Changes To Power Query<\/p>\n<p>If you are planning to become a Microsoft Data Analyst Associate which assesses your Power BI as well as Power query skills, then join the <strong>FREE CLASS<\/strong> now at <em><a href=\"https:\/\/k21academy.com\/da100-microsoft-data-analyst-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=da10002_may21\" target=\"_blank\" rel=\"noopener noreferrer\">k21academy.com\/da10002<\/a><\/em><\/p>\n<p><a href=\"https:\/\/k21academy.com\/da100-microsoft-data-analyst-free-class\/?utm_source=onlineappsdba&amp;utm_medium=referral&amp;utm_campaign=da10002_may21\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"transparent aligncenter\" src=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/04\/DA100_ContentUpgrade-1.gif\" alt=\"https:\/\/k21academy.com\/wp-content\/uploads\/2021\/04\/DA100_ContentUpgrade-1.gif\" width=\"1277\" height=\"191\" \/><\/a><\/p>\n<p>Also, do not forget to join us on our <strong>FREE Telegram<\/strong> group <em><a href=\"https:\/\/t.me\/k21microsoftazure\">t.me\/k21microsoftazure<\/a><\/em> , and be the first to receive Microsoft Azure related news and updates.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog post is going to cover all necessary information about Power Query \u2013 one of the important and powerful [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":16254,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[564,540],"tags":[],"class_list":["post-16253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-data-analyst","category-microsoft-azure"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Introduction to Power Query | Microsoft Azure Power BI Tool<\/title>\n<meta name=\"description\" content=\"Power Query is the heart of Microsoft Power BI ETL service. Connect, ingest and transform data to make data models for BI Reports using Power Query Editor.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Introduction to Power Query | Microsoft Azure Power BI Tool\" \/>\n<meta property=\"og:description\" content=\"Power Query is the heart of Microsoft Power BI ETL service. Connect, ingest and transform data to make data models for BI Reports using Power Query Editor.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-01T09:31:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1125\" \/>\n\t<meta property=\"og:image:height\" content=\"629\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/\",\"name\":\"Introduction to Power Query | Microsoft Azure Power BI Tool\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png\",\"datePublished\":\"2021-05-01T09:31:05+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"description\":\"Power Query is the heart of Microsoft Power BI ETL service. Connect, ingest and transform data to make data models for BI Reports using Power Query Editor.\",\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#primaryimage\",\"url\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png\",\"contentUrl\":\"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png\",\"width\":1125,\"height\":629,\"caption\":\"ower Query Feature Image\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Introduction To Power Query | Microsoft Azure Power BI Tool\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Introduction to Power Query | Microsoft Azure Power BI Tool","description":"Power Query is the heart of Microsoft Power BI ETL service. Connect, ingest and transform data to make data models for BI Reports using Power Query Editor.","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:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/","og_locale":"en_US","og_type":"article","og_title":"Introduction to Power Query | Microsoft Azure Power BI Tool","og_description":"Power Query is the heart of Microsoft Power BI ETL service. Connect, ingest and transform data to make data models for BI Reports using Power Query Editor.","og_url":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/","article_published_time":"2021-05-01T09:31:05+00:00","og_image":[{"width":1125,"height":629,"url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png","type":"image\/png"}],"author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/","url":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/","name":"Introduction to Power Query | Microsoft Azure Power BI Tool","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#primaryimage"},"image":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#primaryimage"},"thumbnailUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png","datePublished":"2021-05-01T09:31:05+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"description":"Power Query is the heart of Microsoft Power BI ETL service. Connect, ingest and transform data to make data models for BI Reports using Power Query Editor.","breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#primaryimage","url":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png","contentUrl":"https:\/\/onlineappsdba.com\/wp-content\/uploads\/2021\/05\/PowerQuery.BI_BlogImage.png","width":1125,"height":629,"caption":"ower Query Feature Image"},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2021\/05\/01\/power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Introduction To Power Query | Microsoft Azure Power BI Tool"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=16253"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/16253\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media\/16254"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=16253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=16253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=16253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}