Category: Power BI
-
#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…
-
#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…
-
#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…
