{"id":27222,"date":"2020-12-17T16:06:37","date_gmt":"2020-12-17T16:06:37","guid":{"rendered":"https:\/\/www.testpreptraining.com\/tutorial\/?page_id=27222"},"modified":"2020-12-18T10:17:37","modified_gmt":"2020-12-18T10:17:37","slug":"shape-and-combine-data-in-power-bi-desktop","status":"publish","type":"page","link":"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/","title":{"rendered":"Shape and Combine Data in Power BI Desktop"},"content":{"rendered":"\n<p>The Power BI Desktop, helps to connect many different types of data sources, then shape the data to meet your needs. Further it enables you to create visual reports to share with others.&nbsp;We may define <em>shaping<\/em>&nbsp;data as transforming the data including renaming columns or tables, changing text to numbers, removing rows, setting the first row as headers, and more.&nbsp;On the other hand we may define, <em>Combining<\/em>&nbsp;data as the means to connect to two or more data sources, thereby shaping them as needed, consolidating them into a useful query.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Steps to Shape Data<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>Firstly, from the&nbsp;<strong>Add Column<\/strong>&nbsp;ribbon, select&nbsp;<strong>Custom Column<\/strong>, which lets you add a custom column.<\/li><li>Secondly, in the&nbsp;<strong>Custom Column<\/strong>&nbsp;window, in&nbsp;<strong>New column name<\/strong>, enter&nbsp;<em>New Rank<\/em>. In&nbsp;<strong>Custom column formula<\/strong>, enter the data.<\/li><li>Then, make sure the status message is&nbsp;<em>No syntax errors have been detected<\/em>, and select&nbsp;<strong>OK<\/strong>.<\/li><li>Next, to keep column data consistent, transform the new column values to whole numbers. To change them, right-click the column header, and then select&nbsp;<strong>Change Type &gt; Whole Number<\/strong>.<\/li><li>In the next step, to&nbsp;<em>transform<\/em>&nbsp;column data types, in which you transform the current data type to another, select&nbsp;<strong>Data Type Text<\/strong>&nbsp;from the&nbsp;<strong>Transform<\/strong>&nbsp;ribbon.<\/li><li>Lastly, in&nbsp;<strong>Query Settings<\/strong>, the&nbsp;<strong>Applied Steps<\/strong>&nbsp;list reflects any shaping steps applied to the data. To remove a step from the shaping process, select the&nbsp;<strong>X<\/strong>&nbsp;to the left of the step.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Steps to combine Data<\/strong><\/h3>\n\n\n\n<ol class=\"wp-block-list\"><li>From the&nbsp;<strong>Home<\/strong>&nbsp;ribbon in Query Editor, select&nbsp;<strong>New Source &gt; Web<\/strong>.<\/li><li>Enter the address of the website for state abbreviations,&nbsp;and then select&nbsp;<strong>Connect<\/strong>.<\/li><li>Select&nbsp;<strong>Codes and abbreviations<\/strong>.<\/li><\/ol>\n\n\n\n<p>Learn more visit &#8211; <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-shape-and-combine-data\" target=\"_blank\" rel=\"noreferrer noopener\">Shape and combine data in Power BI Desktop<\/a><\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter\"><a href=\"https:\/\/www.testpreptraining.ai\/microsoft-power-platform-fundamentals-pl-900-free-practice-test\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png\" alt=\"Microsoft Exam PL-900 Free Practice Test\"\/><\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>The Power BI Desktop, helps to connect many different types of data sources, then shape the data to meet your needs. Further it enables you to create visual reports to share with others.&nbsp;We may define shaping&nbsp;data as transforming the data including renaming columns or tables, changing text to numbers, removing rows, setting the first row&#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":[],"tags":[],"class_list":["post-27222","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Shape and Combine Data in Power BI Desktop | Testprep Training<\/title>\n<meta name=\"description\" content=\"Qualify Microsoft Power Platform Fundamentals PL-900 Exam with the latest practice test. Learn to Combine Data in Power BI Desktop 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\/shape-and-combine-data-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=\"Shape and Combine Data in Power BI Desktop | Testprep Training\" \/>\n<meta property=\"og:description\" content=\"Qualify Microsoft Power Platform Fundamentals PL-900 Exam with the latest practice test. Learn to Combine Data in Power BI Desktop Now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/\" \/>\n<meta property=\"og:site_name\" content=\"Testprep Training Tutorials\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-18T10:17:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/\",\"url\":\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/\",\"name\":\"Shape and Combine Data in Power BI Desktop | Testprep Training\",\"isPartOf\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/#website\"},\"datePublished\":\"2020-12-17T16:06:37+00:00\",\"dateModified\":\"2020-12-18T10:17:37+00:00\",\"description\":\"Qualify Microsoft Power Platform Fundamentals PL-900 Exam with the latest practice test. Learn to Combine Data in Power BI Desktop Now!\",\"breadcrumb\":{\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.testpreptraining.ai\/tutorial\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Shape and Combine Data 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":"Shape and Combine Data in Power BI Desktop | Testprep Training","description":"Qualify Microsoft Power Platform Fundamentals PL-900 Exam with the latest practice test. Learn to Combine Data in Power BI Desktop 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\/shape-and-combine-data-in-power-bi-desktop\/","og_locale":"en_US","og_type":"article","og_title":"Shape and Combine Data in Power BI Desktop | Testprep Training","og_description":"Qualify Microsoft Power Platform Fundamentals PL-900 Exam with the latest practice test. Learn to Combine Data in Power BI Desktop Now!","og_url":"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/","og_site_name":"Testprep Training Tutorials","article_modified_time":"2020-12-18T10:17:37+00:00","og_image":[{"url":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2020\/12\/testpreptraining.ai-4-750x117.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/","url":"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/","name":"Shape and Combine Data in Power BI Desktop | Testprep Training","isPartOf":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/#website"},"datePublished":"2020-12-17T16:06:37+00:00","dateModified":"2020-12-18T10:17:37+00:00","description":"Qualify Microsoft Power Platform Fundamentals PL-900 Exam with the latest practice test. Learn to Combine Data in Power BI Desktop Now!","breadcrumb":{"@id":"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.testpreptraining.ai\/tutorial\/shape-and-combine-data-in-power-bi-desktop\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.testpreptraining.ai\/tutorial\/"},{"@type":"ListItem","position":2,"name":"Shape and Combine Data 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\/27222","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=27222"}],"version-history":[{"count":3,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27222\/revisions"}],"predecessor-version":[{"id":27281,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/pages\/27222\/revisions\/27281"}],"wp:attachment":[{"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/media?parent=27222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/categories?post=27222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.testpreptraining.ai\/tutorial\/wp-json\/wp\/v2\/tags?post=27222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}