-
Continue reading →: How to Access Files in Microsoft Fabric Lakehouse Using Notebooks
Introduction Microsoft Fabric’s lakehouse architecture provides a powerful foundation for storing and processing data at scale. One of the key capabilities is accessing files stored in the lakehouse directly from Fabric notebooks using both pandas and PySpark. This approach allows data professionals to seamlessly work with various file formats while…
-
Continue reading →: Connect to Excel and CSV Files Stored in Your Microsoft Fabric Lakehouse
Introduction Microsoft Fabric represents a significant advancement in the data analytics ecosystem, offering a unified platform that brings together various data services. One of the key components of Fabric is the lakehouse, which combines the best features of data lakes and data warehouses. In this blog post, we’ll walk through…
-
Continue reading →: Creating a Date Table Using Notebook in Microsoft Fabric
In this post, I’m excited to share the code that I use to create a comprehensive date table in a Notebook within Microsoft Fabric. If you are using Notebooks for your ETL processes or want to leverage GitHub or Azure DevOps for version control and continuous integration, this approach is…
-
Continue reading →: Creating a Date Table Using Power Query M in Power BI Desktop or Dataflow Gen 2
In this post, I’m excited to share the Power Query M code that I use to create a comprehensive date table in Power BI. This method can be applied in both Power BI Desktop and Dataflow Gen 2. Whether you’re prefer to work in Power BI Desktop or add the…
-
Continue reading →: The New Era of Data Management: Introducing Multiple App Creation in Fabric Workspace
The data management landscape is constantly evolving, and Microsoft is at the forefront with its latest feature: the Fabric Org App. Currently in public preview, this innovative addition enhances the functionality of Power BI workspace apps by integrating them into Microsoft Fabric as a new item type. Let’s explore the…
-
Continue reading →: Connect vscode to Fabric – Mac Silicon
In this step-by-step guide, you will learn how to connect Visual Studio Code to Fabric on a Mac Silicon. This lets you write and run notebooks in Visual Studio Code, using the Fabric kernel to execute your code. By connecting Visual Studio Code to Fabric, you can take advantage of…
-
Continue reading →: Connect to OneLake Using Azure Storage Explorer
OneLake is a unified data lake included with every Microsoft Fabric tenant, designed to handle large volumes of data from various sources. It serves as a central hub for all your analytics data, ensuring one accessible copy for multiple analytical engines. This setup enhances collaboration and reduces management overhead by…
-
Continue reading →: Creating Measures in Your Fabric Semantic Model
Measures in Power BI are calculations used in reports and dashboards to analyze data. They are created using DAX (Data Analysis Expressions) and can perform various calculations, such as aggregations, comparisons, and conditional logic. Measures are essential for deriving insights from your data and making informed business decisions. Step 1:…
-
Continue reading →: Create a Relationship in Your Semantic Model
Relationships are connections between tables in a semantic model that define how data is related and can be joined together. They are crucial for building accurate and meaningful reports and insights from your data. By creating relationships between tables, you can establish hierarchies, perform aggregations, and enable time intelligence functions.…
-
Continue reading →: Build a Semantic Model in Fabric Lakehouse
Semantic models are crucial for advanced data analysis and reporting. They allow you to create a structured and understandable representation of your data. This guide will walk you through the process of creating a semantic model based on the tables in your Fabric Lakehouse, making it easier to build comprehensive…
