top of page
The Journal of My Work


Direct Lake on OneLake just went GA. Here's how I'd audit and migrate.
Direct Lake on OneLake hit GA this month. The two flavours, the security shift you can't roll back, and a safe audit-validate-migrate workflow with semantic-link-labs.


I Built a Tool to Size Fabric SKUs
Every Fabric project I've worked on, every single one, has had questions around SKU sizing, capacity, capacity metrics, monitoring, and utilisation. The list goes on. I've been working with Power BI since its early days, and I've been in the BI world for many years before that. In all that time, I don't think I've come across a single product or project where it's easy to say "this is the right size." There's never really a right or wrong answer. I sometimes wonder if that's


A Logging Framework for Microsoft Fabric
A single Python file that creates complete monitoring infrastructure for Microsoft Fabric: lakehouse, tables, semantic model with relationships and DAX measures. Deploy in 5 minutes and start tracking your ETL pipelines immediately.


Designing with Intent: The Power of Visual Cues in BI Dashboards
Building AI agents to create Power BI reports taught me something crucial: functional doesn't mean usable. My agent kept cramming everything onto one screen because it didn't understand design intent. This post explores visual cues and the principles that make dashboards intuitive, not just technically correct.


Update Semantic Model column names with SemPy
SemPy offers many possibilities with Semantic Models in Microsoft Fabric, some of which are remarkably effective and simplify some tedious tasks. As Data Analytics Developers, we often debate the best naming conventions. However, business users expect us to set aside our fixation on naming conventions and create more readable outputs with a simple design. When we create our models for Power Users, Self-Service BI users, or Power BI designers, they need simple, explainable nam


Efficiently Moving Items Between Workspaces with Fabric CLI
Copying Power BI reports or notebooks across Fabric workspaces isn’t exactly smooth — especially if you want to move things in bulk. In this blog, I walk through how I used the Fabric CLI inside a notebook to automate this task.
No external tooling, no manual fiddling. Just a smart little hack with:
• Environment-based authentication
• Folder ID lookups (with auto-create if missing)
• Safe copy logic with fab cp
• Final clean-up with a folder PATCH


How to Clone and Rebind Power BI Semantic Models
Cloning a semantic model or report in Power BI isn’t always recommended—but sometimes, it’s the smartest move. Whether you’re juggling multiple environments or building templates for different domains, this step-by-step guide shows how to clone semantic models and reports with Python using sempy_labs, and rebind them with ease.


Naming Convention Ideas for Microsoft Fabric Developments
Naming conventions are a small but crucial part of creating effective data solutions. In this post, I explore how to do in Microsoft Fabric


Exploring Relationships in Semantic Models with #SemPy
Understanding the relationships between datasets is crucial in data analytics, especially in the world of self-service BI. Sempy, a Python library unique…


March Madness with conferences
Can you believe how amazing and hectic March has been?! So many community members got to experience some major conferences all…


#MicrosoftFabric Road Map and Web Scraping with Fabric
Like many I am also playing with Fabric, many of my clients are also excited about Fabric and want to know…


Document #PowerBI Workspaces with #MicrosoftFabric #Notebooks
If you are a consultant like me, you know how hard it can be to access Power BI Admin API or…


What is #MicrosoftFabric and why am I excited about it?
I had been following the hints and clues on Twitter, where some Power BI team members were changing their job titles…


Switch between a summarized value or selected value with multiple legends
A colleague of mine came to me with an interesting use case, “ Switch between a summarized value or selected value…


Using Tree Map as legend on a page in Power BI
I recently worked on two projects where the client wanted to show multiple metrics sliced by the same categorical data. For…


Showing the number of selected items in a #PowerBI slicer
In one of the projects, I was working on, I received feedback saying it is hard to understand how many items…


#Power BI Slicer – Slicer properties to make it look sleeker
In my recent open data project, I created a single page report model with a sparse slicer. It’s a good trick…


#PowerBI Buttons with animation
The inspiration behind this post solely came from WHO website https://www.who.int/. I went onto to check some COVID data and found…


#PowerBI Bookmarks vs Page Navigation
Power BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks were portrayed…


#POWERBI REPORTS LANDING PAGE TIPS AND TRICKS: Progressive disclosure design approach in Power BI using Card pattern
What is Progressive Disclosure? Progressive disclosure is an interaction design pattern that sequences information and actions across several screens (e.g., a…
bottom of page