Quick guide to convert Power BI Direct Lake models to Import mode and rebind reports using Semantic Link Labs. Perfect for publishing open d

You are not alone! I recently completed some work for a client regarding orphaned deployment pipelines. In small teams, where one or two...

In my last post, I discussed how I've been using Sempy and SemPy Labs to convert column names to Snake Case . This post will explore the...

SemPy offers many possibilities with Semantic Models in Microsoft Fabric, some of which are remarkably effective and simplify some...

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

It’s one of those blog posts I write for my own reference as I often find myself needing this code. I hope it helps someone out there too...

Understanding the relationships between datasets is crucial in data analytics, especially in the world of self-service BI. Sempy , a...

Documentation is a critical and tedious part of every project. However, it is essential to review existing developments or document new...

If you are a consultant like me, you know how hard it can be to access Power BI Admin API or Service Principal. Sometimes, you need to...

I had been following the hints and clues on Twitter, where some Power BI team members were changing their job titles to Synapse. I was...

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

I recently worked on two projects where the client wanted to show multiple metrics sliced by the same categorical data. For example,...

In one of the projects I was working on, I received feedback saying it is hard to understand how many items they have selected in a...

In my recent open data project, I created a single page report model with a sparse slicer. It’s a good trick for anyone who wants to make...

The inspiration behind this post solely came from WHO website https://www.who.int/ . I went onto to check some COVID data and found quick...

Power BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks...

What is Progressive Disclosure? Progressive disclosure is an interaction design pattern that sequences information and actions across...

This is a blog post series to show various ways of creating parts of landing pages for better UX and navigation Tiles using,...

A quick post, how many times in Power BI Desktop, have you clicked on “No, remove the files.” and then say OOPS! Well, I did plenty of...

Hello all, My 2019 was restless; hence my blog, London #PowerBI UG posts went almost quiet. Well, the good news is I have committed to...