Introduction In this tutorial, we will walk through the steps required to write a PySpark DataFrame to a Delta table in Microsoft Fabric. We'll start by creating an example DataFrame, then demonstrate how to write it to a Delta table. Goal An example PySpark DataFrame should be created...
Introduction In Microsoft Fabric, notebooks can interact very closely with lakehouses. In this tutorial, we will explain step-by-step how to connect a lakehouse and a notebook in Microsoft Fabric. Goal A lakehouse and a notebook should be connected. Prequestisies ☑️ Notebook created We have already created the notebook "dlnerds_notebook&...
Introduction One key component of Microsoft Fabric is the Lakehouse. In a lakehouse, custom schemas can be created to group tables together. In this tutorial, we will explain step-by-step how to create a lakehouse schema. Goal A new lakehouse schema should be created. Step 1: Sign in to Fabric First,...
Introduction Kusto Query Language (KQL) databases are essential components for real-time analytics in Microsoft Fabric. In this tutorial, we will explain step-by-step how to add a new KQL Database to an existing Eventhouse. Goal A new KQL Database should be added to an existing Eventhouse. Step 1: Open Real-Time Intelligence...
Introduction Power BI comes with the powerful formula language Data Analysis Expression (DAX) which allows the implementation of custom calculations. There are numerous operators and functions available in DAX. One important DAX function is the CONCATENATE function. With the CONCATENATE function, two text values can be merged into one text...
Introduction Microsoft Fabric is a powerful All-in-One Data Platform (SaaS) in the Azure Cloud that combines various Azure components to cover the fields of Data Integration, Data Engineering, Data Science and Business Intelligence. One key component of the Microsoft Fabric architecture is the Eventhouse. In this tutorial, we will explain...
Introduction The first step when creating a Power BI report is to connect with data sources. Power BI can connect to a wide range of data sources. This capability allows users to access and analyze data from various sources within Power BI. One important format to often deal with is...
Introduction Microsoft Fabric offers with the Data Explorer a powerful tool to visualize, analyze and explore query results. It offers an intuitive interface to create visualizations and filters. In this tutorial, we will explain step-by-step how to visualize the results of a T-SQL query using the Data Explorer in Microsoft...
Introduction In Power BI, the visualization and interpretation of data in a table can be improved by using conditional formatting with icons. This feature dynamically adds icons to a table based on the values it contains. This allows important information to be highlighted so that patterns, trends and outliers can...
