Month: June 2023
-
#8 Microsoft Fabric: Create SQL Query and view
We can manage our warehouse within our workspace by using SQL endpoint. In this test, we will write a SQL statement that calculates the total sales amount by month. We’ll then save this statement as a view in our SQL endpoint (Warehouse). This will allow us to easily access the total sales amount by month…
-
#7 Microsoft Fabric: Create & work with notebooks in LakeHouse
It’s amazing. We can easily create a Fabric Notebook within the LakeHouse. We do not need to do any jobs for configuration for Spark, Scala, or Python to run the script. What you need to do is just drag & drop, and then let Fabric automatically generate codes for us. Let’s try it now to…
-
Microsoft Fabric Licensing
A Microsoft Fabric subscription consists of tenants, capacities, and workspaces and can be organized in various ways according to your organizational needs. This illustration provides two example subscriptions, each organized differently. Typically, companies organize their subscription in a model that resembles the Retail company A example. Licensing includes: 1. Capacity unit cost 2. Storage Cost…
-
#6 Microsoft Fabric: Data model – create relationships in the Lakehouse
In this article, we’ll create a star schema that you might see from data warehouses: It resembles a star. The center of the star is a Fact table. The surrounding tables are called Dimension tables, which are related to the Fact table with relationships. Let’s get started! 1. In the workspace view, select the SQL…
-
#5 Microsoft Fabric: Create data Pipeline using Data Factory
The Pipeline in Microsoft Fabric comes from Azure Data Factory which allows us to execute a group of actions and combine them into a single workflow. For example, we may want to create the Pipeline to send out an email, copy data and save it somewhere, run a procedure, etc. In this article, we will…
-
#4 Microsoft Fabric: Prepare and load data into your LakeHouse
To prepare and load data into your lakehouse, take the following steps: 1. From your Power BI Workspace, select your Lakehouse to navigate to the Lakehouse editor 2. Once you’re in the Lakehouse editor, select New Dataflow Gen2. 83. Once you’re in the Power Query Online editor for Dataflows Gen2, select Import from a Power Query template and choose the…
-
#3 Microsoft Fabric: Create LakeHouse to store structure and unstructure data
To store structure and unstructure data from Power BI, you can create a LakeHouse by following the below steps. 1. Navigate to your Power BI > Workspaces > select New workspace > Configure your new workspace > then Apply. 2. Navigate to the new workspace to create a new Lakehouse 2.1. Select New > then…
-
#2 Microsoft Fabric: Configure to enable Microsoft Fabric
To enable Microsoft Fabric, follow steps below. You need Power BI Admin right (or Microsoft 365 Global admin, Power Platform admin). 1. Login to Microsoft Power BI with your Account and go to Power BI Admin Portal 2. Navigate to the tenant settings > Microsoft Fabric (Preview), and expand the Users can create Fabric items (public…