{"id":58804,"date":"2023-09-30T08:39:20","date_gmt":"2023-09-30T03:09:20","guid":{"rendered":"https:\/\/www.tothenew.com\/blog\/?p=58804"},"modified":"2023-10-06T09:01:43","modified_gmt":"2023-10-06T03:31:43","slug":"microsoft-fabric-an-umbrella-for-data-analytics-services","status":"publish","type":"post","link":"https:\/\/www.tothenew.com\/blog\/microsoft-fabric-an-umbrella-for-data-analytics-services\/","title":{"rendered":"Microsoft Fabric: An Umbrella for Data Analytics Services"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">Microsoft Fabric is an end-to-end, cloud-based SaaS solution for data and analytics. It is built on top of an open lakehouse (OneLake) and weaves together multiple Microsoft tools to streamline all data and analytics workflows, from data integration to data engineering to data science.<\/span><\/p>\n<h2><strong>What is Microsoft Fabric, and why is it needed?<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">Microsoft Fabric is a platform that brings together various Microsoft tools and services. In many organizations, different teams handle different aspects of data management. These include data engineering, data storage in data warehouses (DWH) and data lakes, and data analytics or data science. Typically, each of these teams maintains its own separate data platforms and solutions. This often leads to data duplication and increased costs. <\/span><span style=\"font-weight: 400;\">This is where Microsoft Fabric comes into play. It aims to unify all these disparate elements into a single platform, eliminating redundancy, reducing costs, and ensuring data security and privacy. Microsoft Fabric introduces the concept of a centralized data repository called &#8220;One Lake.&#8221; This repository stores data in the widely used Delta Parquet format, an industry standard. The idea is that only one copy of the data is stored centrally in One Lake, which increases efficiency and reduces data duplication across different tools and services.<\/span><\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58768 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/Architecture-1-1024x589.png\" alt=\"\" width=\"625\" height=\"359\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/Architecture-1-1024x589.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Architecture-1-300x173.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Architecture-1-768x442.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Architecture-1-624x359.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Architecture-1.png 1100w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<h2><b>Microsoft Fabric Highlights:<\/b><\/h2>\n<p><span style=\"font-weight: 400;\"><span style=\"font-weight: 400;\"><strong>1. One copy of data &#8211; One Lake<\/strong>: Microsoft Fabric introduces &#8220;One Lake,&#8221; a central repository that ensures only one copy of your data, reducing duplication.<\/span><\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>2.<\/strong> <strong>Unified Integrated Environment<\/strong>: Microsoft Fabric provides a unified environment where-<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The &#8220;Warehouse&#8221; works like a database.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The &#8220;Lake House&#8221; works like a data lake.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Power BI&#8221; can access both Warehouse and Lakehouse data.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">You can access and manipulate data through SQL endpoints.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">You can run custom queries and real-time analytics.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Perform data science experiments.<\/span><\/li>\n<\/ul>\n<p><strong>3.<\/strong> <span style=\"font-weight: 400;\"><strong>One Security<\/strong>: One Security ensures that permissions are enforced consistently across all engines, increasing data security and simplifying security permission management for organizations using the platform.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>\u00a04.<\/strong> <strong>Common compute<\/strong>: Unlike traditional configurations where you purchase storage for a data lake and separate compute power for a data warehouse, Microsoft Fabric provides a shared compute resource. This shared computing power can be used to process data in the data lake, manage the warehouse, and run analytic queries in Power BI.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><strong>5.<\/strong> <strong>Components of Microsoft Fabric<\/strong>: Microsoft Fabric brings together the best parts of data mesh, data fabric, and data hub to\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0provide a one-stop shop for data integration, data engineering, real-time analytics, data science, and business intelligence\u00a0<\/span><\/p>\n<h2><b>What is One-Lake in Microsoft Fabric?<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Since we have been talking about One Lake, we should talk more about it. One of the most exciting things in Fabric that I have found is OneLake. I was amazed to discover that OneLake is simplified just like OneDrive! The goal of OneLake is to provide a single place for all data, breaking down data silos and simplifying management (security\/governance\/data discovery) for your organization&#8217;s data. The solution is built on the robust foundation of Azure Data Lake Storage Gen2.<\/span><\/p>\n<p><b>Getting Started with Microsoft Fabric &#8211; How to Enable Fabric in app.powerbi.com<\/b><\/p>\n<p><span style=\"font-weight: 400;\">1. If you want to try Fabric in your tenant, you need to enable the Fabric capabilities in your Power BI admin portal. To do this, go to <\/span><a href=\"https:\/\/app.powerbi.com\/.\"><span style=\"font-weight: 400;\">https:\/\/app.powerbi.com\/.<\/span><\/a><br \/>\n<strong>Note: You must be a Power BI administrator, and Microsoft Fabric Capacity(Trial) or Power BI Premium Capacity is required to get started with Microsoft Fabric.<\/strong><\/p>\n<p>2. You can also obtain a free trial version once you activate the trial. You have 60 days to try it.<\/p>\n<p>3. Go to the Power BI service (https:\/\/app.powerbi.com) and open the admin portal. (You need administrator rights for Power BI to see this menu item shown below.)<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58770\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/Admin.png\" alt=\"\" width=\"240\" height=\"464\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/Admin.png 423w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Admin-155x300.png 155w\" sizes=\"(max-width: 240px) 100vw, 240px\" \/><\/p>\n<p>4. Navigate to the Power BI Admin Portal. This must be done by the Power BI tenant administrator or Office 365 tenant administrator. In the Admin Portal, under Tenant Settings, find the first option for Microsoft Fabric (Preview). Enable it. You can enable it for the entire organization or for a specific security group.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58771 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/Point-2-1024x518.png\" alt=\"\" width=\"625\" height=\"316\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/Point-2-1024x518.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Point-2-300x152.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Point-2-768x389.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Point-2-624x316.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/Point-2.png 1134w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>Once you make the change, it will take up to 15 minutes, and then you should see some effects of Microsoft Fabric in your tenant.<\/p>\n<p><strong>5.<\/strong> In the lower left corner, you will see all the key components. Click the Microsoft Fabric option. You are redirected to the Microsoft Fabric home page.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58772 size-full\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/1-2.png\" alt=\"\" width=\"844\" height=\"337\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/1-2.png 844w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/1-2-300x120.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/1-2-768x307.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/1-2-624x249.png 624w\" sizes=\"(max-width: 844px) 100vw, 844px\" \/><\/p>\n<p>This is the complete Microsoft Fabric home page where you will see other Microsoft Fabric workloads and can navigate to them.<br \/>\n<img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58773 size-full\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/2-1.png\" alt=\"\" width=\"945\" height=\"381\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/2-1.png 945w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/2-1-300x121.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/2-1-768x310.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/2-1-624x252.png 624w\" sizes=\"(max-width: 945px) 100vw, 945px\" \/><\/p>\n<p>Note: The complete Microsoft Fabric setup can be found at https:\/\/learn.microsoft.com\/en-us\/fabric\/admin\/fabric-switch<\/p>\n<p>Now that we have Fabric enabled in https:\/\/app.powerbi.com\/, we can begin the demo to show how we can load the data into the lakehouse, then query data with SQL Endpoint and use the same data set for creating reports in Power BI.<\/p>\n<p><strong>The following steps are required to load the data into Lakehouse.<\/strong><\/p>\n<p>1. To get started, we first created a workspace, &#8220;Test_Fabric\u201d in https:\/\/app.powerbi.com\/.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58774 size-full\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S1.png\" alt=\"\" width=\"597\" height=\"646\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S1.png 597w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S1-277x300.png 277w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/p>\n<p>Then, navigate to the &#8220;New&#8221; option and select &#8220;Show All&#8221; to explore the various components available.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58775 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2-1024x464.png\" alt=\"\" width=\"625\" height=\"283\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2-1024x464.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2-300x136.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2-768x348.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2-1536x697.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2-624x283.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S2.png 1832w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>2. For demonstration purposes, we&#8217;ll focus on creating a &#8220;lake house&#8221;.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58776 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4-1024x452.png\" alt=\"\" width=\"625\" height=\"276\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4-1024x452.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4-300x132.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4-768x339.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4-1536x678.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4-624x275.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S4.png 1747w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>3. Once we&#8217;ve successfully created this new lake house, return to your workspace. Here, you&#8217;ll see that three components have been created with the same name. These components are:<br \/>\nLakehouse: This is the main area in which you&#8217;ll be working. It serves as the core of your data operations within the Lakehouse environment.<\/p>\n<p><strong>SQL Endpoint<\/strong>: The SQL Endpoint provides read-only access to your data. It allows you to query and retrieve information from your Lakehouse.<\/p>\n<p><strong>Default dataset:<\/strong> This is where you&#8217;ll find your data. The default dataset is the location of your data that you can access and work with as needed.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58777 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5-1024x238.png\" alt=\"\" width=\"625\" height=\"145\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5-1024x238.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5-300x70.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5-768x178.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5-1536x357.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5-624x145.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S5.png 1817w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>4. The creation of the lake house has been completed. However, it does not yet contain tables or data. So we will add these. There are several ways to load data into the lakehouse. Any of the following methods can be used to load data into the lakehouse.<\/p>\n<ul>\n<li>Data Flows Gen2<\/li>\n<li>Data Pipelines<\/li>\n<li>Notebooks<\/li>\n<li>Apache Spark job definitions<\/li>\n<li>The Lakehouse explorer<\/li>\n<\/ul>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58778 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6-1024x495.png\" alt=\"\" width=\"625\" height=\"302\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6-1024x495.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6-300x145.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6-768x371.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6-1536x742.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6-624x301.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S6.png 1917w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>5. Let\u2019s just load data into the lake house by using the data Pipeline. On the home page of your lakehouse, select New Data Pipeline and create a new data pipeline. The copy data wizard will open as shown below.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58779 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10-1024x493.png\" alt=\"\" width=\"625\" height=\"301\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10-1024x493.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10-300x144.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10-768x370.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10-1536x739.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10-624x300.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S10.png 1542w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>In the copy data wizard, on the Choose data source step, Select the sample data \u201cRetail Data Model from Wide World Importers\u201d. Click \u201cNext\u201d and go to the next step which is \u201cConnect to data source\u201d and select the table that you want to use. Ex dimension_city.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58780 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S11-1024x498.png\" alt=\"\" width=\"625\" height=\"304\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S11-1024x498.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S11-300x146.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S11-768x373.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S11-624x303.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S11.png 1537w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>6. Click \u201cNext\u201d and go to the next step which is \u201cChoose data destination\u201d. It will list down all the lake houses that are part of the workspaces.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58783 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12-1024x496.png\" alt=\"\" width=\"625\" height=\"303\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12-1024x496.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12-300x145.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12-768x372.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12-1536x744.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12-624x302.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S12.png 1570w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>7. Click \u201cNext\u201d and go to the next step, which is \u201cConnect to data destination.\u201d Here, you can also do a mapping of your column fields. This mapping can also be done later.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58781 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13-1024x495.png\" alt=\"\" width=\"625\" height=\"302\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13-1024x495.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13-300x145.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13-768x371.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13-1536x742.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13-624x301.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S13.png 1538w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>Then click on \u201cNext\u201d and review this and Save.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58782 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14-1024x490.png\" alt=\"\" width=\"625\" height=\"299\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14-1024x490.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14-300x143.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14-768x367.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14-1536x735.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14-624x298.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S14.png 1541w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>8. A New Screen will open \u201c Copy summary page\u201d. On the copy summary page, you can review the details of the copy operation, such as previewing the data, correcting the mapping of the columns (e.g., changing the data types, editing the column names, etc.), and then click &#8220;Validate&#8221; to validate the pipeline, then save it and run the operation.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58784 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S15-1024x648.png\" alt=\"\" width=\"625\" height=\"396\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S15-1024x648.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S15-300x190.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S15-768x486.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S15-624x395.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S15.png 1347w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>9. When the pipeline starts to run, you can monitor its status in the output area under the pipeline designer. Use the \u21bb (Refresh) icon to update the status and wait until it succeeds. Repeat these steps (3 to 7) to add new tables.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58786 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18-1024x340.png\" alt=\"\" width=\"625\" height=\"208\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18-1024x340.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18-300x100.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18-768x255.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18-1536x509.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18-624x207.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S18.png 1830w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>10. Go to the lakehouse, and here you can find the tables that you copy in the lakehouse. These are two tables that are loaded here: dimension_city and fact_sale. You can also create views.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58787 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19-1024x514.png\" alt=\"\" width=\"625\" height=\"314\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19-1024x514.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19-300x150.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19-768x385.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19-1536x771.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19-624x313.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S19.png 1818w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>11. Select \u201cSQL Endpoint\u201d from the dropdown menu in the upper right corner and preview your data by selecting one of the tables as shown below.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58788 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20-1024x433.png\" alt=\"\" width=\"625\" height=\"264\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20-1024x433.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20-300x127.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20-768x325.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20-1536x650.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20-624x264.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S20.png 1831w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>You can also query the data using SQL.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58789 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21-1024x426.png\" alt=\"\" width=\"625\" height=\"260\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21-1024x426.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21-300x125.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21-768x320.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21-1536x639.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21-624x260.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S21.png 1822w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>12. Select the Model tab at the bottom and create a data model. Below is an example of a data model where I connected the two tables using the CityKey column. Here dimension_city is a dimension table\/lookup table, and fact_sales is a fact table.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58790 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S24-1024x574.png\" alt=\"\" width=\"625\" height=\"350\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S24-1024x574.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S24-300x168.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S24-768x431.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S24-624x350.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S24.png 1467w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>13. Once the data model is created, you need to click on \u201cNew Report\u201d. This will open Power BI Wizard where you can create new reports.<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"alignnone wp-image-58791 size-large\" src=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26-1024x496.png\" alt=\"\" width=\"625\" height=\"303\" srcset=\"\/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26-1024x496.png 1024w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26-300x145.png 300w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26-768x372.png 768w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26-1536x745.png 1536w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26-624x303.png 624w, \/blog\/wp-ttn-blog\/uploads\/2023\/09\/S26.png 1912w\" sizes=\"(max-width: 625px) 100vw, 625px\" \/><\/p>\n<p>With the process written above, you can load the data into the lakehouse. There are other ways by which you can load the data into the lakehouse, like using Dataflow GEN2, Notebooks Apache Spark job definitions, etc.<\/p>\n<p><strong>Here are the Quick Links for Microsoft Fabric:<\/strong><br \/>\nOfficial Document:\u00a0 https:\/\/learn.microsoft.com\/en-us\/fabric\/get-started\/fabric-trial<br \/>\nBuy a Microsoft Fabric subscription: https:\/\/learn.microsoft.com\/en-us\/fabric\/enterprise\/buy-subscription<\/p>\n<h2><strong>Summary<\/strong><\/h2>\n<p>Microsoft Fabric simplifies the data analytics landscape. By integrating various tools and services under one umbrella, it allows organizations to focus on results rather than the complexities of technology.<\/p>\n<div class=\"ap-custom-wrapper\"><\/div><!--ap-custom-wrapper-->","protected":false},"excerpt":{"rendered":"<p>Microsoft Fabric is an end-to-end, cloud-based SaaS solution for data and analytics. It is built on top of an open lakehouse (OneLake) and weaves together multiple Microsoft tools to streamline all data and analytics workflows, from data integration to data engineering to data science. What is Microsoft Fabric, and why is it needed? Microsoft Fabric [&hellip;]<\/p>\n","protected":false},"author":1656,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":47},"categories":[4685,4831],"tags":[5478],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/58804"}],"collection":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/users\/1656"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/comments?post=58804"}],"version-history":[{"count":2,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/58804\/revisions"}],"predecessor-version":[{"id":59123,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/posts\/58804\/revisions\/59123"}],"wp:attachment":[{"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/media?parent=58804"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/categories?post=58804"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tothenew.com\/blog\/wp-json\/wp\/v2\/tags?post=58804"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}