Category: Microsoft Fabric
-
#10 Microsoft Fabric: Boost Your Power BI with Python Integration
Are you ready to supercharge your Power BI experience with Python scripting? Follow these steps to seamlessly integrate Python into Power BI and unlock powerful data analysis capabilities: Step 1: Update Power BI Desktop Always use the latest version for optimal performance. Avoid the AppStore and download directly from Microsoft’s official site: Step 2: Install…
-
DAX Query: Power up your Power BI!
Instead of using an external tool like Dax Studio, you can now write DAX queries and their interaction without leaving Power BI Desktop. This gives you a lot of advantages in building your semantic model. Several advantages that you can do: What stuff you can apply straight away? Here are some examples: Here is the…
-
Microsoft Fabric: Are you ready to employ an all-in-one analytics solution?
As I have a look, almost all the main features are ready now. Dataverse is now linked to Fabric using Synapse Link for Dataverse. It is quite ok as I have done some tests. Data Activator is also in Public Preview. As we can centralize data everywhere in MS Fabric and sync data across the…
-
#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…
