Articles by Abiola David

Create a Databricks SQL materialized view that refreshes daily, documents its columns, and calculates reporting metrics in a single statement.

Learn how to convert a Power BI .pbix report into a reusable .pbit template and understand its benefits for reuse, data privacy, and reporting consistency.

Learn how to define a PySpark schema, create a sales DataFrame, and write it as a Delta table in a Microsoft Fabric Lakehouse.

Learn how to upload local files to a Microsoft Fabric Lakehouse, store them in OneLake, and load CSV data into Delta tables for analysis.

Learn how Microsoft Fabric Materialized Lake Views materialize Lakehouse transformations, optimize refreshes, enforce data quality, and support medallion architecture pipelines.

Learn how to share a Microsoft Fabric Lakehouse, assign read, SQL, and Spark permissions, and manage user access without granting workspace access.

Learn how to create a Microsoft Fabric capacity from the Manage Capacities page in the Monitor hub, including configuration options, permissions, and provisioning steps.

Learn how to use Microsoft Fabric Capacity Monitoring to review capacity health, CU utilisation, throttling, SKUs, regions, and capacity management options.

Learn how Databricks AI/BI Dashboard dataset relationships connect data sources, enable cross-filtering, and support more interactive self-service analytics.

Learn how Databricks Unity Catalog secrets centralize credential storage, permissions, rotation, auditing, and secure use in notebooks and Python UDFs.

Learn how Power BI's Design ribbon centralizes report themes, page size, backgrounds, wallpaper, and light or dark appearance settings.

In this article, you'll learn how Databricks Auto Loader actually works under the hood - not just the five-line tutorial version. It covers file discovery (directory listing vs. event-based), the five schema evolution modes and when to use each, throughput controls like maxFilesPerTrigger and maxBytesPerTrigger, file metadata and lineage, the built-in cloud_files_state() audit function, trigger strategy, and what Auto Loader's exactly-once guarantee actually promises (and doesn't

In this article, I walk through the exact steps I used to integrate a JSON sales file into a Microsoft Fabric Lakehouse using Dataflow Gen2 — from connecting to the JSON source and expanding its nested structure, to fixing data types, mapping the output to a Lakehouse table, and publishing the dataflow for a clean, queryable result.

A plain-English walkthrough of the Power BI service's core vocabulary: semantic models, reports, dashboards, workspaces, apps, licensing, capacity, Copilot, workbooks, and dataflows — explained through the lens of the two types of people who use the platform: the creators who build content and the business users who consume it. Ideal for anyone new to Power BI who wants the terminology to finally click.

In this article, I covered how to read and write JSON multiline data from Databricks' unity catalog volume to delta table

In this article, I demonstrated how to treat numerical column containing positive and negative numbers to all positive numbers using the ABS and Number.Abs functions in Power BI and Power Query

In this article, we explored how to create Sales and Marketing schemas in a Microsoft Fabric Lakehouse and use a Fabric Notebook to create and write tables into their respective schemas. The demonstration used PySpark to create sample data and save it as Delta tables.

Learn how to reassign an existing Power BI Pro workspace to a Fabric Capacity directly from the Microsoft Fabric Admin Portal

A practical introduction to the Microsoft Fabric Admin Portal, covering tenant settings, capacity management, domains, monitoring, governance, security, and the difference between tenant-level and workspace administration.

In my latest article, I demonstrate how to connect multiple Lakehouses to a Fabric Notebook and switch between them when needed, using Sales and Marketing Lakehouses as an example. A simple but useful feature for Fabric data engineers and developers.

Learn how to use Lock Objects in Power BI Service to prevent visuals, buttons, images, shapes, and other report elements from accidental movement or resizing.

Discover how Excel’s DATABRICKS.SQL and DATABRICKS.TABLE functions connect spreadsheets directly to Databricks, enabling live SQL queries, enterprise data analysis, and real-time insights.

Learn how to run multiple SELECT statements in a Microsoft Fabric Warehouse and easily switch between their individual result sets. Using practical examples with Region, Product, and Orders tables, this article shows how multiple queries can simplify data exploration, validation, troubleshooting, and everyday SQL development in Fabric.

Learn to calculate shipping days in Fabric Dataflow Gen2 using Power Query. Handle date types, missing values, and invalid dates for robust data transformation.