{"id":31630,"date":"2021-01-13T12:17:38","date_gmt":"2021-01-13T12:17:38","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=31630"},"modified":"2021-01-13T12:19:18","modified_gmt":"2021-01-13T12:19:18","slug":"overview-of-query-in-power-bi-desktop","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/","title":{"rendered":"Overview of Query in Power BI Desktop"},"content":{"rendered":"\n<p>We use Power BI Desktop for not only connecting to the world of data but also creating foundational reports. Together with sharing your efforts with others who can use your work, and thereby expand their business intelligence efforts.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Types of Views in Power BI Desktop<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Report<\/strong>&nbsp;<strong>view<\/strong> \u2013 Under report view, you can use queries to create and build compelling visualizations, arranged as you want them to be displayed, together with multiple pages, that you wish to share with others.<\/li><li><strong>Data<\/strong>&nbsp;<strong>view <\/strong>\u2013 As per the data view we can see the data in your report in data model format, such that you can add measures, create new columns, and manage relationships.<\/li><li><strong>Relationships<\/strong>&nbsp;<strong>view <\/strong>\u2013 The relationships view helps to get a graphical representation of the relationships that have been established in the data model, and manage or modify them as required.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Power Query Editor<\/strong> <strong>in Power BI Desktop<\/strong><\/h3>\n\n\n\n<p>Power BI Desktop also has the Power Query Editor. You can use the Power Query Editor for connecting with one or many data sources, shape and transform the data to meet the specified requirements, and then load that model into Power BI Desktop.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, to get to Power Query Editor, select&nbsp;<strong>Edit Queries<\/strong>&nbsp;from the&nbsp;<strong>Home<\/strong>&nbsp;tab of Power BI Desktop. <\/li><li>Then, with no data connections, Power Query Editor appears as a blank pane, ready for data.<\/li><li>Once a query is loaded, Power Query Editor view becomes more interesting.<\/li><li>We can then connect to the Web data source, Power Query Editor loads information about the data, which you can then begin to shape<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Appearance of Power Query Editor <\/strong><\/h4>\n\n\n\n<p>Following are the ways in which Power Query Editor appears once a data connection is established.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The Query Ribbon<\/strong><\/h4>\n\n\n\n<p>The query ribbon in Power Query Editor consists of four tabs:&nbsp;<strong>Home<\/strong>,&nbsp;<strong>Transform<\/strong>,&nbsp;<strong>Add Column<\/strong>, and&nbsp;<strong>View<\/strong>.<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Home<\/strong>&nbsp;tab contains the common query tasks.<\/li><li><strong>Transform<\/strong>&nbsp;tab provides access to common data transformation tasks, like Adding or removing columns, Changing data types, Splitting columns and Other data-driven tasks.<\/li><li>The&nbsp;<strong>Add Column<\/strong>&nbsp;tab provides additional tasks associated with adding a column, formatting column data, and adding custom columns.<\/li><li>The&nbsp;<strong>View<\/strong>&nbsp;tab on the ribbon is used to toggle whether certain panes or windows are displayed.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The Left (Queries) Pane<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>The left pane, or&nbsp;Queries&nbsp;pane, helps to display the number of active queries and the name of the query. <\/li><li>So, when you select a query from the left pane, its data is displayed in the center pane, where you can shape and transform the data to meet your needs. <\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The Center (Data) Pane<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>In the center pane, or&nbsp;<strong>Data<\/strong>&nbsp;pane, data from the selected query is displayed. <\/li><li>Moreover, this pane is where much of the work of the&nbsp;<strong>Query<\/strong>&nbsp;view is accomplished.<\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>The Right (Query Settings) Pane<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, the right pane, or\u00a0<strong>Query Settings<\/strong>\u00a0pane, is where all steps associated with a query are displayed.\u00a0<\/li><li>Also, the\u00a0<strong>Applied Steps<\/strong>\u00a0section of the\u00a0<strong>Query Settings<\/strong>\u00a0pane reflects the fact that we just changed the type of the\u00a0<strong>Overall score<\/strong>\u00a0column.<\/li><\/ul>\n\n\n\n<p>For more Details visit &#8211; <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/transform-model\/desktop-query-overview\" target=\"_blank\" rel=\"noreferrer noopener\">Power Query Editor<\/a><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><a href=\"https:\/\/www.testpreptraining.ai\/analyzing-data-with-microsoft-power-bi-da-100-free-test\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" width=\"961\" height=\"150\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" alt=\"Microsoft Exam DA-100 Free Practice Test\" class=\"wp-image-31483\" srcset=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png 961w, https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test-750x117.png 750w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We use Power BI Desktop for not only connecting to the world of data but also creating foundational reports. Together with sharing your efforts with others who can use your work, and thereby expand their business intelligence efforts. Types of Views in Power BI Desktop Report&nbsp;view \u2013 Under report view, you can use queries to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"footnotes":""},"categories":[174],"tags":[1830,3954,3966,3965],"class_list":["post-31630","page","type-page","status-publish","hentry","category-microsoft-azure","tag-da-100-study-guide","tag-microsoft-exam-da-100-free-practice-test","tag-power-bi-desktop","tag-power-query-editor"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Overview of Query in Power BI Desktop - Testprep Training Tutorials<\/title>\n<meta name=\"description\" content=\"Learn more about Query in Power BI Desktop with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\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.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Overview of Query in Power BI Desktop - Testprep Training Tutorials\" \/>\n<meta property=\"og:description\" content=\"Learn more about Query in Power BI Desktop with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-13T12:19:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/\",\"name\":\"Overview of Query in Power BI Desktop - Testprep Training Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2021-01-13T12:17:38+00:00\",\"dateModified\":\"2021-01-13T12:19:18+00:00\",\"description\":\"Learn more about Query in Power BI Desktop with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Overview of Query in Power BI Desktop\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"name\":\"Testprep Training Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#organization\",\"name\":\"Testprep Training\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"contentUrl\":\"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png\",\"width\":583,\"height\":153,\"caption\":\"Testprep Training\"},\"image\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Overview of Query in Power BI Desktop - Testprep Training Tutorials","description":"Learn more about Query in Power BI Desktop with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","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.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Overview of Query in Power BI Desktop - Testprep Training Tutorials","og_description":"Learn more about Query in Power BI Desktop with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2021-01-13T12:19:18+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/","name":"Overview of Query in Power BI Desktop - Testprep Training Tutorials","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2021-01-13T12:17:38+00:00","dateModified":"2021-01-13T12:19:18+00:00","description":"Learn more about Query in Power BI Desktop with online tutorial and free practice test. Start preparing for Microsoft Exam DA-100 Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/overview-of-query-in-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Overview of Query in Power BI Desktop"}]},{"@type":"WebSite","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","name":"Testprep Training Tutorials","description":"","publisher":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.testpreptraining.ai\/tutorial\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#organization","name":"Testprep Training","url":"https:\/\/www.testpreptraining.ai\/tutorial\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/","url":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","contentUrl":"https:\/\/www.testpreptraining.com\/tutorial\/wp-content\/uploads\/2020\/07\/tpt-logo-6.png","width":583,"height":153,"caption":"Testprep Training"},"image":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/31630","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/comments?post=31630"}],"version-history":[{"count":4,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/31630\/revisions"}],"predecessor-version":[{"id":31687,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/31630\/revisions\/31687"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=31630"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=31630"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=31630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}