{"id":30215,"date":"2023-12-28T14:15:19","date_gmt":"2023-12-28T14:15:19","guid":{"rendered":"https:\/\/chartexpo.com\/blog\/?p=30215"},"modified":"2025-11-12T18:11:58","modified_gmt":"2025-11-12T13:11:58","slug":"sample-data-for-power-bi","status":"publish","type":"post","link":"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi","title":{"rendered":"Fueling Insights: The Importance of Sample Data for Power BI"},"content":{"rendered":"<p>Data is the currency of insight, and Power BI is the alchemist&#8217;s tool of choice. But before you can turn your data into gold, you need data to begin with.<\/p>\n<p>That&#8217;s where sample data for Power BI comes in.<\/p>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/sample-data-for-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" style=\"max-width: 100%;\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/sample-data-for-power-bi.jpg\" alt=\"Sample Data For Power BI \" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk0NTMrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTQ1Mys=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTQ1Mys=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<p>Sample data is the lifeblood of effective Power BI analysis. It&#8217;s the fuel that powers your dashboards and reports, allowing you to explore, visualize, and glean insights. But where do you get this sample data, and how do you import it into Power BI?<\/p>\n<p>The internet has a feast of sample data to sink your teeth into.<\/p>\n<p>There&#8217;s an array of options, from sales and returns to artificial intelligence. These samples are also available in various formats, including content packs and downloadable Excel workbooks.<\/p>\n<p>Don&#8217;t know where to start? No problem. Microsoft has made it easy to access and connect to the sample data. You&#8217;ll explore the full range of Power BI&#8217;s features with just a few clicks.<\/p>\n<p>Power BI has never been more fun.<\/p>\n<h3>Table of Contents:<\/h3>\n<ol>\n<li><a href=\"#tb1\">What is Sample Data in Power BI?<\/a><\/li>\n<li><a href=\"#tb2\">How to Get Sample Data for Power BI?<\/a><\/li>\n<li><a href=\"#tb3\">Best Practice for Sample Data in Power BI<\/a><\/li>\n<li><a href=\"#tb4\">Evaluate Sample Data in Power BI<\/a><\/li>\n<li><a href=\"#wrap-up\">Wrap Up<\/a><\/li>\n<\/ol>\n<h2>What is Sample Data in Power BI?<\/h2>\n<p>Power BI sample data is a subset used for practice and testing within the <a href=\"https:\/\/chartexpo.com\/blog\/business-intelligence-analytics\" target=\"_blank\" rel=\"noopener noreferrer\">Power BI analytics platform<\/a>. It typically consists of mock or simplified data that resembles real-world information. Discover the significance of Sample Data for Power BI, an essential subset facilitating a deeper understanding of Power BI&#8217;s features, aiding in report building, and exploring <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-advanced\" target=\"_blank\" rel=\"noopener noreferrer\">advanced visualization<\/a> techniques. This resource is pivotal for the learning and development of Power BI enthusiasts and professionals, ensuring proficiency in analytics skills<\/p>\n<h2 id=\"tb2\">How to Get Sample Data for Power BI?<\/h2>\n<p>There are several sources and methods to obtain Power BI sample datasets:<\/p>\n<ul>\n<li>\n<h3>Microsoft Power BI Desktop<\/h3>\n<\/li>\n<\/ul>\n<p>Power BI Desktop includes a built-in sample data generator. You can create tables, input data manually, and customize it to your needs for practicing and testing. Click the &#8220;Get Data&#8221; button and select &#8220;Samples&#8221; to access the data samples.<\/p>\n<ul>\n<li>\n<h3>Power BI Service<\/h3>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/chartexpo.com\/blog\/power-bi-service\" target=\"_blank\" rel=\"noopener noreferrer\">Power BI Service<\/a> offers sample data packs and templates to import directly into your workspace. These packs cover various industries and scenarios, making starting easy. Click the &#8220;Get Data&#8221; or &#8220;Connect to Data&#8221; buttons to access them.<\/p>\n<ul>\n<li>\n<h3>Microsoft Power BI Community<\/h3>\n<\/li>\n<\/ul>\n<p>The Power BI Community is a valuable resource. You can find templates and sample datasets shared by the community members. These datasets often cater to specific business cases and can be downloaded for free.<\/p>\n<p>Visit the Power BI Community website (<u>https:\/\/community.powerbi.com<\/u>). Then, check the &#8220;Data Stories Gallery&#8221; or the &#8220;Themes, templates, and apps&#8221; sections for downloadable sample datasets.<\/p>\n<ul>\n<li>\n<h3>Public Data Sources<\/h3>\n<\/li>\n<\/ul>\n<p>Many organizations and government websites provide access to public datasets on various topics, such as demographics and economics. You can download these <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-dataset\" target=\"_blank\" rel=\"noopener noreferrer\">datasets used in Power BI<\/a>.<\/p>\n<ul>\n<li>\n<h3>Third-Party Sources<\/h3>\n<\/li>\n<\/ul>\n<p>Some third-party platforms and data marketplaces offer sample datasets for free or purchase. These datasets cover diverse industries and can be a rich <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-connectors\" target=\"_blank\" rel=\"noopener noreferrer\">source for Power BI<\/a>.<\/p>\n<h2 id=\"tb3\">Best Practice for Sample Data in Power BI<\/h2>\n<p>Embrace the wizardry of Power BI sample data with enchanting best practices. Discover how to wield Sample Data for Power BI wisely to unlock its magical potential and optimize your analytics experience:<\/p>\n<ol>\n<li><strong>Understand the purpose: <\/strong>Before you dive headfirst into data lakes, figure out why you&#8217;re there. Are you hunting for insights, calculating the <a href=\"https:\/\/chartexpo.com\/blog\/no-of-days-between-two-dates\" target=\"_blank\" rel=\"noopener\"><em>No. of Days Between Two Dates<\/em><\/a>, or just sharpening your Power BI skills? Knowing your quest will guide your sample data choices.<\/li>\n<li><strong>Use official sources:<\/strong> No pirate wants fake treasure maps; your official treasure trove lies in Sample Data for Power BI. Utilize sample datasets from Microsoft and other reliable sources to ensure data accuracy and reliability in your analytics adventures.<\/li>\n<li><strong>Document the Schema:<\/strong> Be the cartographer of your data world. Sketch out the relationships and structure of your data. This schema documentation is crucial for <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-data-model\" target=\"_blank\" rel=\"noopener noreferrer\">designing data models<\/a> and creating visualizations.<\/li>\n<li><strong>Practice data modeling:<\/strong> Apply data modeling principles, such as creating relationships, hierarchies, and calculated columns, using Sample Data for Power BI. This approach mimics real-world scenarios, preparing you for more complex data challenges in your analytics journey.<\/li>\n<li><strong>Data cleansing and transformation:<\/strong> Every adventurer needs a shower and makeover. Cleanse and <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-transform-data\" target=\"_blank\" rel=\"noopener noreferrer\">transform your data<\/a> to reflect the real world, warts and all. This teaches you how to handle data inconsistencies and prepares you for real-world challenges.<\/li>\n<li><strong>Create meaningful visualizations: <\/strong>Your data deserves the red carpet treatment. Craft <a href=\"https:\/\/chartexpo.com\/tools\/power-bi-custom-visuals\" target=\"_blank\" rel=\"noopener noreferrer\">stunning visuals<\/a> that tell the story, not just numbers.<\/li>\n<li><strong>Explore diverse scenarios:<\/strong> Don&#8217;t be a one-trick pony. Use various datasets to tackle different business scenarios. From sales to HR, you&#8217;re the swashbuckler of data!<\/li>\n<li><strong>Learn DAX:<\/strong> Invest time in learning DAX, as it&#8217;s a powerful language for creating custom calculations and measures. Apply DAX functions to enhance your reports&#8217; functionality.<\/li>\n<li><strong>Performance optimization:<\/strong> Speed matters! Optimize your data models and reports like a finely tuned ship. Learn techniques like <a href=\"https:\/\/chartexpo.com\/blog\/data-visualization-guide\" target=\"_blank\" rel=\"noopener noreferrer\">data visualization<\/a>, using appropriate visuals, and managing relationships efficiently.<\/li>\n<li><strong>Documentation: <\/strong>Document your Sample Data for Power BI, including the <a href=\"https:\/\/chartexpo.com\/blog\/power-bi-income-statement\" target=\"_blank\" rel=\"noopener noreferrer\">income statement report example<\/a>, models, and report design choices. This documentation serves as a valuable resource for knowledge sharing and troubleshooting in your analytics endeavors.<\/li>\n<\/ol>\n<h2 id=\"tb4\">Evaluate Sample Data for Power BI<\/h2>\n<p data-pm-slice=\"0 0 []\">You can use a <a href=\"https:\/\/chartexpo.com\/charts\/sankey-diagram\" target=\"_blank\" rel=\"noopener\">Sankey chart<\/a> to evaluate sample data and visualize how values move between different categories.<\/p>\n<h3>Stage 1: Logging in to Power BI<\/h3>\n<ul>\n<li>Log in to Power BI.<\/li>\n<li>Enter your email. Click the \u201c<strong>Submit<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-to-login-to-power-bi.jpg\" alt=\"Enter email to login to Power BI\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>You are redirected to your Microsoft account.<\/li>\n<li>Enter your password and click \u201c<strong>Sign in\u201d<\/strong>.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-password-to-login-to-power-bi.jpg\" alt=\"Enter Password to login to Power BI\" width=\"363\" \/><\/a><\/div>\n<ul>\n<li>Choose whether to stay signed in.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-stay-signed-in.jpg\" alt=\"Click on stay signed in\" width=\"392\" \/><\/a><\/div>\n<div>\n<ul>\n<li>Once done, the Power BI home screen will open.<\/li>\n<\/ul>\n<\/div>\n<h3>Stage 2: <strong>Creating a Data Set and Selecting the Data Set to Use in Your Sankey Chart<\/strong><\/h3>\n<ul>\n<li>Go to the left-side menu and click the \u201c<strong>Create<\/strong>\u201d button.<\/li>\n<li>Select \u201c<strong>Paste or manually enter data<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/select-paste-or-manually-enter-data-in-power-bi-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/select-paste-or-manually-enter-data-in-power-bi-ce453.jpg\" alt=\"select Paste or manually enter data in Power BI ce453\" width=\"624\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk0NTMrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTQ1Mys=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTQ1Mys=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<ul>\n<li>We&#8217;ll use the following cash flow data for this example.<\/li>\n<\/ul>\n<table class=\"static\" style=\"table-layout: fixed; overflow-x: auto; border: 1px; font-size: 17px;\">\n<tbody>\n<tr>\n<td width=\"82\"><strong>Total Cost<\/strong><\/td>\n<td width=\"111\"><strong>Company Type<\/strong><\/td>\n<td width=\"167\"><strong>Company Name<\/strong><\/td>\n<td width=\"90\"><strong>Expertise Categories<\/strong><\/td>\n<td width=\"113\"><strong>Expertise<\/strong><\/td>\n<td width=\"59\"><strong>Cost<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Subcontractor<\/td>\n<td width=\"167\">Skyline Contractors<\/td>\n<td width=\"90\">Mechanical Installation<\/td>\n<td width=\"113\">Plumbing &amp; Heating<\/td>\n<td width=\"59\">15456<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Subcontractor<\/td>\n<td width=\"167\">Skyline Contractors<\/td>\n<td width=\"90\">Mechanical Installation<\/td>\n<td width=\"113\">Mechanical Work<\/td>\n<td width=\"59\">10159<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Subcontractor<\/td>\n<td width=\"167\">Onyx General Contractors<\/td>\n<td width=\"90\">Mechanical Installation<\/td>\n<td width=\"113\">Plumbing &amp; Heating<\/td>\n<td width=\"59\">18045<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Subcontractor<\/td>\n<td width=\"167\">Onyx General Contractors<\/td>\n<td width=\"90\">Mechanical Installation<\/td>\n<td width=\"113\">Mechanical Work<\/td>\n<td width=\"59\">12695<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Subcontractor<\/td>\n<td width=\"167\">Living Well Remodeling<\/td>\n<td width=\"90\">Mechanical Installation<\/td>\n<td width=\"113\">Plumbing &amp; Heating<\/td>\n<td width=\"59\">14589<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Subcontractor<\/td>\n<td width=\"167\">Living Well Remodeling<\/td>\n<td width=\"90\">Mechanical Installation<\/td>\n<td width=\"113\">Welding<\/td>\n<td width=\"59\">11456<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Supplier<\/td>\n<td width=\"167\">Power-up Builders<\/td>\n<td width=\"90\">Raw Material<\/td>\n<td width=\"113\">Cement<\/td>\n<td width=\"59\">20561<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Supplier<\/td>\n<td width=\"167\">Power-up Builders<\/td>\n<td width=\"90\">Raw Material<\/td>\n<td width=\"113\">Steel<\/td>\n<td width=\"59\">32456<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Supplier<\/td>\n<td width=\"167\">Five-star Construction<\/td>\n<td width=\"90\">Raw Material<\/td>\n<td width=\"113\">Bricks<\/td>\n<td width=\"59\">10253<\/td>\n<\/tr>\n<tr>\n<td width=\"82\">Total Cost<\/td>\n<td width=\"111\">Supplier<\/td>\n<td width=\"167\">Five-star Construction<\/td>\n<td width=\"90\">Raw Material<\/td>\n<td width=\"113\">Timber<\/td>\n<td width=\"59\">9000<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Paste the above data table in the Power Query Window.<\/li>\n<li>Select the \u201c<strong>Create a dataset only<\/strong>\u201d option.<\/li>\n<\/ul>\n<div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/create-dataset-in-power-bi-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/create-dataset-in-power-bi-ce453.jpg\" alt=\"Create Dataset in Power BI ce453\" width=\"624\" \/><\/a><\/div>\n<\/div>\n<ul>\n<li>On the left-side menu, click \u201c<strong>Data Hub<\/strong>\u201c.<\/li>\n<li>Power BI populates the data set list. (If you have not created a data set, refer to the Error! Reference source not found section).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/click-on-data-hub-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/click-on-data-hub-ce453.jpg\" alt=\"Click on Data Hub ce453\" width=\"624\" \/><\/a><\/div>\n<ul>\n<li>Choose a data set for the Sankey chart.<\/li>\n<li>PBI populates the screen as shown below:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/workspace-in-power-bi-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/workspace-in-power-bi-ce453.jpg\" alt=\"Workspace in Power BI ce453\" width=\"624\" \/><\/a><\/div>\n<div>\n<ul>\n<li>Click on the \u201c<strong>Create a report<\/strong>\u201d dropdown.<\/li>\n<li>Select \u201c<strong>Start from scratch<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/create-report-and-start-from-scratch-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/create-report-and-start-from-scratch-ce453.jpg\" alt=\"Create Report and start from scratch ce453\" width=\"624\" \/><\/a><\/div>\n<\/div>\n<ul>\n<li>A Report Canvas screen appears as below:<\/li>\n<\/ul>\n<div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/report-canvas-screen-in-power-bi-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/report-canvas-screen-in-power-bi-ce453.jpg\" alt=\"Report Canvas screen in Power BI ce453\" width=\"624\" \/><\/a><\/div>\n<\/div>\n<h3>Stage 3: Adding the Power BI Sankey Diagram Extension by ChartExpo<\/h3>\n<ul>\n<li>Creating the Sankey Diagram requires us to use an add-in or Power BI visual from AppSource.<\/li>\n<li>Navigate to the right side of the Power BI dashboard.<\/li>\n<li>Open the Power BI Visualizations panel.<\/li>\n<li>Click the ellipsis symbol (&#8230;) as highlighted in the diagram below. This will import the Power BI Sankey Diagram extension by ChartExpo.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/click-on-to-get-more-visuals-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/click-on-to-get-more-visuals-ce453.jpg\" alt=\"click on to get more visuals ce453\" width=\"385\" \/><\/a><\/div>\n<ul>\n<li>The following menu opens:<\/li>\n<li>Select the \u201c<strong>Get more visuals<\/strong>\u201d option.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/get-more-visuals-in-power-bi-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/get-more-visuals-in-power-bi-ce453.jpg\" alt=\"get more visuals in Power BI ce453\" width=\"425\" \/><\/a><\/div>\n<ul>\n<li>The following window opens.<\/li>\n<li>Enter \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d in the highlighted search box.<\/li>\n<li>You should see the \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d, as shown in the image below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/sankey-diagram-for-power-bi-by-chartexpo.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/sankey-diagram-for-power-bi-by-chartexpo.jpg\" alt=\"Sankey Diagram for Power BI by ChartExpo\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Click the highlighted \u201c<strong>Add<\/strong>\u201d button.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-the-add-button.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-the-add-button.jpg\" alt=\"Click the Add button\" width=\"650\" \/><\/a><\/div>\n<ul>\n<li>Power BI will add the \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d icon in the visualization panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-sankey-diagram-icon.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/click-on-sankey-diagram-icon.jpg\" alt=\"Click on Sankey Diagram Icon\" width=\"187\" \/><\/a><\/div>\n<h3>Stage 4: Drawing a Sankey Diagram with ChartExpo&#8217;s Power BI extension<\/h3>\n<ul>\n<li>Select the \u201c<strong>Sankey Diagram for Power BI by ChartExpo<\/strong>\u201d icon in the visualization panel.<\/li>\n<li>The following window opens in the report section of your dashboard:<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/report-section-in-dashboard-ce441.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/report-section-in-dashboard-ce441.jpg\" alt=\"Report Section in Dashboard ce441\" width=\"297\" \/><\/a><\/div>\n<ul>\n<li>You can resize the visual as needed.<\/li>\n<li>Navigate to the right side of your Power BI dashboard.<\/li>\n<li>You should see \u201c<strong>Fields<\/strong>\u201d next to \u201c<strong>Visualizations<\/strong>\u201c.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/fields-next-to-visualizations-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/fields-next-to-visualizations-ce453.jpg\" alt=\"Fields next to visualizations ce453\" width=\"355\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll select the fields to use in your Sankey chart here.<\/li>\n<li>The ChartExpo visual needs to be selected, though. Select the field in the following sequence:<\/li>\n<li style=\"list-style-type: none;\">\n<ul>\n<li>Total Cost<\/li>\n<li>Company Type<\/li>\n<li>Company Name<\/li>\n<li>Expertise Categories<\/li>\n<li>Expertise<\/li>\n<li>Cost<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/select-fields-for-sankey-diagram-ce453.png\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/select-fields-for-sankey-diagram-ce453.png\" alt=\"Select fields for Sankey diagram ce453\" width=\"174\" \/><\/a><\/div>\n<ul>\n<li>You&#8217;ll be asked for a ChartExpo license key or email address.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/11\/enter-email-for-chartexpo-license-ce430.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/11\/enter-email-for-chartexpo-license-ce430.jpg\" alt=\"enter email for ChartExpo license ce430\" width=\"531\" \/><\/a><\/div>\n<h3>Stage 5: <strong>Activate <\/strong>your ChartExpo Trial or Apply a Subscription Key<\/h3>\n<ul>\n<li>Select the ChartExpo visual.<\/li>\n<li>You should see three icons below \u201c<strong>Build Visual<\/strong>\u201d in the Visualizations panel.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/build-visual-panel-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/build-visual-panel-in-power-bi.jpg\" alt=\"Build visual panel in Power BI\" width=\"203\" \/><\/a><\/div>\n<ul>\n<li>Select the middle icon, \u201c<strong>Format visual<\/strong>\u201c. The visual properties will be populated as shown below.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/visual-properties-in-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/visual-properties-in-power-bi.jpg\" alt=\"visual properties in Power BI\" width=\"183\" \/><\/a><\/div>\n<ul>\n<li>To begin using ChartExpo as a new user;\n<ul>\n<li>Enter your email address in the textbox under the \u201c<strong>Trial Mode<\/strong>\u201d section. ChartExpo will send the License key to this email upon subscribing to the add-in.<\/li>\n<li>Ensure you provide an accurate and up-to-date email address.<\/li>\n<li>Toggle \u201c<strong>Enable Trial<\/strong>\u201d to activate your 7-day trial.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-id.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-email-id.jpg\" alt=\"enter email id\" width=\"180\" \/><\/a><\/div>\n<ul>\n<li>You should receive a welcome email from ChartExpo.<\/li>\n<li>If you do not find the email in your inbox, kindly check your spam folder.<\/li>\n<li>The Sankey Diagram you create under the 7-day trial contains the ChartExpo watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/sample-data-for-power-bi-1.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/sample-data-for-power-bi-1.jpg\" alt=\"Sample Data For Power BI 1 \" width=\"624\" \/><\/a><\/div>\n<ul>\n<li>If you have obtained a license key:\n<ul>\n<li>Enter your license key in the \u201c<strong>ChartExpo License Key<\/strong>\u201d textbox in the \u201c<strong>License Settings<\/strong>\u201d section (see below).<\/li>\n<li>Slide the toggle switch next to \u201c<strong>Enable License<\/strong>\u201d to \u201c<strong>On<\/strong>\u201c.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-license-key.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/05\/enter-license-key.jpg\" alt=\"enter license key\" width=\"197\" \/><\/a><\/div>\n<ul>\n<li>Your Sankey Diagram will then appear without a watermark.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/sample-data-for-power-bi-2.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/sample-data-for-power-bi-2.jpg\" alt=\"Sample Data For Power BI 2 \" width=\"624\" \/><\/a><\/div>\n<ul>\n<li>Let&#8217;s add the Prefix (e.g., $ sign) to the chart&#8217;s numeric values.<\/li>\n<li>Expand the &#8220;Stats&#8221; properties. Add the Prefix value (e.g., $ sign).<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/add-prefix-value-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/add-prefix-value-ce453.jpg\" alt=\"Add Prefix Value ce453\" width=\"624\" \/><\/a><\/div>\n<div>\n<ul>\n<li>Let&#8217;s add colors to each node. Expand the \u201c<strong>Level Colors<\/strong>\u201d properties and select the colors.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/coloring-sankey-diagram-ce453.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/coloring-sankey-diagram-ce453.jpg\" alt=\"Coloring Sankey Diagram ce453\" width=\"182\" \/><\/a><\/div>\n<\/div>\n<ul>\n<li>Automatically all changes will be saved.<\/li>\n<\/ul>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/final-sample-data-for-power-bi.jpg\"><img decoding=\"async\" class=\"alignnone size full wp image 4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/final-sample-data-for-power-bi.jpg\" alt=\"Final Sample Data For Power BI \" width=\"624\" \/><\/a><\/div>\n<div style=\"text-align: center;\"><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytwYitjZXhwbytQQkk0NTMrU2Fua2V5Kw==\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-power-bi.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/utmAction\/MTYrYmxvZytncytjZXhwbytDRTQ1Mys=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-google-sheets.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><a href=\"https:\/\/chartexpo.com\/TrafficTracker\/MTYrYmxvZytzZStjZXhwbytDRTQ1Mys=\" target=\"_blank&quot;\" rel=\"noopener noreferrer nofollow\"><img decoding=\"async\" class=\"alignnone size-full wp-image-4345\" src=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/04\/CTA-in-microsoft-excel.jpg\" alt=\"\" width=\"205\" height=\"113\" \/><\/a><\/div>\n<h4>Insights<\/h4>\n<ul>\n<li><strong>Cost Distribution by Company Type<\/strong><\/li>\n<\/ul>\n<p>Subcontractors are the main beneficiaries of the &#8220;Total Cost.&#8221; To better understand the distribution, calculate the precise allocation of the total cost to subcontractors and suppliers.<\/p>\n<ul>\n<li><strong>Most Costly Expertise Categories<\/strong><\/li>\n<\/ul>\n<p>&#8216;Mechanical Installation&#8217; has the highest expertise expenses, with notable costs attributed to the &#8216;Plumbing &amp; Heating&#8217; and &#8216;Mechanical Work&#8217; subcategories.<\/p>\n<ul>\n<li><strong>Company Performance<\/strong><\/li>\n<\/ul>\n<p>The performance of subcontractors and suppliers is evaluated based on the total cost they receive. The sub-contractors, Skyline Contractors, Onyx General Contractors, and Living Well Remodeling charged $25.6K, $30.7K, and $26.0K, respectively. The suppliers, Power-up Builder and Five-star Construction charged $53.0K and $19.3K, respectively.<\/p>\n<h2>FAQs<\/h2>\n<h3>What is Sample Data for Power BI?<\/h3>\n<p>Sample Data for Power BI is a collection of pre-made datasets available within the Power BI platform. These datasets resemble real-world scenarios but use simplified data, making them perfect for learning, practicing, and testing your Power BI skills without needing complex data configurations.<\/p>\n<h3>What are the benefits of using Sample Data for Power BI?<\/h3>\n<ul>\n<li>Learn the ropes: Sample data provides a safe environment to get familiar with Power BI features like building reports, crafting visualizations, and applying data transformations, without the pressure of real-world data complexity.<\/li>\n<li>Experiment freely: Dive into different chart types, analysis models, and functionalities without worrying about data limitations or potential errors in real-world projects.<\/li>\n<li>Boost your confidence: Build essential skills and gain confidence in using Power BI before tackling real-world data analysis, making you a more effective data analyst.<\/li>\n<li>Spark creativity: Explore diverse datasets and get inspired by different data scenarios, fueling your imagination and helping you create impactful visualizations for your reports.<\/li>\n<\/ul>\n<h3>Where can I find Sample Data for Power BI?<\/h3>\n<p>Sample data is readily available within Power BI Desktop itself. You can access it by:<\/p>\n<ul>\n<li>Going to the &#8220;Get Data&#8221; section within Power BI Desktop.<\/li>\n<li>Selecting &#8220;Samples&#8221; from the available data sources.<\/li>\n<li>Choosing the specific sample data set you&#8217;d like to work with.<\/li>\n<\/ul>\n<h4 id=\"wrap-up\">Wrap Up<\/h4>\n<p>Harnessing sample data for Power BI is akin to sharpening a sword before battle, essential for success. It empowers you to experiment, learn, and innovate within this dynamic data ecosystem. Understanding its purpose and using official sources ensures you&#8217;re on the right track.<\/p>\n<p>We&#8217;ve unraveled the mystery of generating and importing Sample Data for Power BI, offering insights into diverse methods and best practices. Documenting the data schema and practicing data modeling prepares you for real-world scenarios where data can be messy.<\/p>\n<p>Cleaning and transforming data, creating meaningful visualizations, and exploring diverse business scenarios refine your skills. Learning DAX adds a potent tool to your data analysis arsenal. Don&#8217;t forget the importance of performance optimization and meticulous documentation to navigate your data journey successfully.<\/p>\n<p>To supercharge your Power BI journey, consider leveraging the innovative ChartExpo. With ChartExpo, you can access an extensive library of pre-built sample datasets tailored for Power BI. This integration lets you focus on what truly matters &#8211; analyzing and visualizing data to uncover meaningful insights.<\/p>\n","protected":false},"excerpt":{"rendered":"<p><p>Understand the importance of sample data for Power BI, fueling insights and optimizing analytics. Elevate reporting with curated real-world data samples.<\/p>\n&nbsp;&nbsp;<a href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\"><\/a><\/p>","protected":false},"author":1,"featured_media":30232,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1017],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>Fueling Insights: The Importance of Sample Data for Power BI -<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:title\" content=\"Fueling Insights: The Importance of Sample Data for Power BI -\" \/>\r\n<meta name=\"twitter:description\" content=\"Understand the importance of sample data for Power BI, fueling insights and optimizing analytics. Elevate reporting with curated real-world data samples.\" \/>\r\n<meta name=\"twitter:image\" content=\"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/feature-ce453-200x200-1.jpg\" \/>\r\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=\"17 minutes\" \/>\r\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fueling Insights: The Importance of Sample Data for Power BI -","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:\/\/chartexpo.com\/blog\/sample-data-for-power-bi","twitter_card":"summary_large_image","twitter_title":"Fueling Insights: The Importance of Sample Data for Power BI -","twitter_description":"Understand the importance of sample data for Power BI, fueling insights and optimizing analytics. Elevate reporting with curated real-world data samples.","twitter_image":"https:\/\/chartexpo.com\/blog\/wp-content\/uploads\/2023\/12\/feature-ce453-200x200-1.jpg","twitter_misc":{"Written by":"admin","Est. reading time":"17 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi","url":"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi","name":"Fueling Insights: The Importance of Sample Data for Power BI -","isPartOf":{"@id":"http:\/\/localhost\/blog\/#website"},"datePublished":"2023-12-28T14:15:19+00:00","dateModified":"2025-11-12T13:11:58+00:00","author":{"@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280"},"breadcrumb":{"@id":"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/chartexpo.com\/blog\/sample-data-for-power-bi#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/localhost\/blog"},{"@type":"ListItem","position":2,"name":"Fueling Insights: The Importance of Sample Data for Power BI"}]},{"@type":"WebSite","@id":"http:\/\/localhost\/blog\/#website","url":"http:\/\/localhost\/blog\/","name":"","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/localhost\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"http:\/\/localhost\/blog\/#\/schema\/person\/6aceeb7c948a3f66ff6439ce5c24a280","name":"admin","url":"https:\/\/chartexpo.com\/blog\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/30215"}],"collection":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/comments?post=30215"}],"version-history":[{"count":12,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/30215\/revisions"}],"predecessor-version":[{"id":55626,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/posts\/30215\/revisions\/55626"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media\/30232"}],"wp:attachment":[{"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/media?parent=30215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/categories?post=30215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chartexpo.com\/blog\/wp-json\/wp\/v2\/tags?post=30215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}