Blogs
82 posts on Power BI, Microsoft Fabric and semantic models, newest first. For undated, maintained guidance see the guides.
Microsoft FabricHow I make a semantic model Copilot-readyA small open-source toolkit for making Microsoft Fabric semantic models Copilot-ready, rule-based descriptions, synonyms, safe renames, no AI calls.
Microsoft FabricHow I add descriptions and synonyms to a modelA rule-based generator that adds plain-English descriptions and synonyms to a Microsoft Fabric semantic model, safe, reviewable, and Copilot-ready in an afternoon.
Microsoft FabricHow I rename a published model safelyRename objects on a published Microsoft Fabric semantic model safely, with impact reports, DAX validation, and connected reports rewritten end-to-end.
Microsoft FabricDirect 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
Microsoft FabricI Built a Tool to Size Fabric SKUsEvery Fabric project I've worked on, every single one, has had questions around SKU sizing, capacity, capacity metrics, monitoring, and utilisation.
Microsoft FabricA Logging Framework for Microsoft FabricA single Python file that creates complete monitoring infrastructure for Microsoft Fabric: lakehouse, tables, semantic model with relationships and DAX measures.
Semantic LinkKeep Your Semantic Link Libraries Up to Date in Fabric NotebooksIt's one of those blog posts I write for my own reference, and I suspect many of you will find it useful too.
Agentic DevelopmentFrom Broken Blogs to Polished Posts, How I Built an AI Agent to Fix my Messy ContentIf you prefer to watch, I have recorded a video. - https://youtu.be/70WYukFGvt0 A year ago, I started my solopreneur journey and did what any sensible millennial
Power BIDesigning with Intent: The Power of Visual Cues in BI DashboardsBuilding AI agents to create Power BI reports taught me something crucial: functional doesn't mean usable.
REST APIA Quick Blog Post: Orphaned Deployment PipelinesYou are not alone! I recently completed some work for a client regarding orphaned deployment pipelines.
Power BIA Quick Blog Post – Converting Direct Lake to Import Mode (and Rebinding Reports)Quick guide to convert Power BI Direct Lake models to Import mode and rebind reports using Semantic Link Labs. Perfect for publishing open d
Power BIEfficiently Moving Items Between Workspaces with Fabric CLICopying Power BI reports or notebooks across Fabric workspaces isn’t exactly smooth, especially if you want to move things in bulk.
Semantic LinkUpdate Semantic Model column names with SemPySemPy offers many possibilities with Semantic Models in Microsoft Fabric, some of which are remarkably effective and simplify some tedious tasks.
Power BIHow to Clone and Rebind Power BI Semantic ModelsCloning a semantic model or report in Power BI isn’t always recommended, but sometimes, it’s the smartest move.
Power BICreate and maintain Semantic model measures and calculation groups using Sempy + Sempy LabsIn my last post, I discussed how I've been using Sempy and SemPy Labs to convert column names to Snake Case .
Microsoft FabricNaming Convention Ideas for Microsoft Fabric DevelopmentsNaming conventions are a small but crucial part of creating effective data solutions. In this post, I explore how to do in Microsoft Fabric
Microsoft FabricWrite Data to Unattached Lakehouses with Fabric NotebooksIt’s one of those blog posts I write for my own reference as I often find myself needing this code. I…
Power BIExploring Relationships in Semantic Models with #SemPyUnderstanding the relationships between datasets is crucial in data analytics, especially in the world of self-service BI. Sempy, a Python library unique…
Microsoft FabricDocument your Microsoft Fabric or Power BI workspaces with Semantic Link LabsDocumentation is a critical and tedious part of every project. However, it is essential to review existing developments or document new…
Microsoft FabricMarch Madness with conferencesCan you believe how amazing and hectic March has been?! So many community members got to experience some major conferences all…
Power BI#MicrosoftFabric Road Map and Web Scraping with FabricLike many I am also playing with Fabric, many of my clients are also excited about Fabric and want to know…
Power BIDocument #PowerBI Workspaces with #MicrosoftFabric #NotebooksIf you are a consultant like me, you know how hard it can be to access Power BI Admin API or…
Power BIWhat 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…
Power BISwitch between a summarized value or selected value with multiple legendsA colleague of mine came to me with an interesting use case, “ Switch between a summarized value or selected value…
Power BIUsing Tree Map as legend on a page in Power BII recently worked on two projects where the client wanted to show multiple metrics sliced by the same categorical data. For…
Power BIShowing the number of selected items in a #PowerBI slicerIn one of the projects, I was working on, I received feedback saying it is hard to understand how many items…
Power BI#Power BI Slicer – Slicer properties to make it look sleekerIn my recent open data project, I created a single page report model with a sparse slicer. It’s a good trick…
Power BI#PowerBI Buttons with animationThe inspiration behind this post solely came from WHO website https://www.who.int/. I went onto to check some COVID data and found…
Power BI#PowerBI Bookmarks vs Page NavigationPower BI Bookmarks, the secret behind many sleek reports, It revolutionised the entire PBI Report design approach. Initially, Bookmarks were portrayed…
Power BI#POWERBI REPORTS LANDING PAGE TIPS AND TRICKS: Progressive disclosure design approach in Power BI using Card patternWhat is Progressive Disclosure? Progressive disclosure is an interaction design pattern that sequences information and actions across several screens (e.g., a…
Power BIPower BI reports landing page tips and tricks: Tiles using, Images, Power BI buttons, hover effects and all the aboveThis is a blog post series to show various ways of creating parts of landing pages for better UX and navigation Tiles…
Power BI#PowerBI Auto RecoveryA quick post, how many times in Power BI Desktop, have you clicked on “No, remove the files.” and then say OOPS! Well,…
Power BIJan 2020, London #PowerBI UG DataVizHello all, My 2019 was restless; hence my blog, London #PowerBI UG posts went almost quiet. Well, the good news is…
Power BIHow I designed a layered donut chartThis is a long overdue post, probably one of the most received questions on my blog was, How I designed a…
Power BI#DataLounge video with #AltiusData talking about Storytelling and #PowerBIA few weeks ago I got invited to the DataLounge YouTube series. I went on talking about my favorite topic Storytelling.…
Power BI#PowerBI Card visual to show flags/warningsThis is a long-overdue blog post. A couple of months ago, I worked with a client in Amsterdam; one of the…
Power BIPower BI visual header tooltipLike many things in Power BI, Power BI Tool Tips functionality evolved so much. I probably do a post on Tool…
Power BIPower BI Mobile ReportingSteadily more users are getting interested in Power BI mobile reports, especially when you design reports for executives; they are more…
Power BI#PowerBI Focus Mode and Dark Background ImagesA quick post today. I received an interesting question in a webinar I did recently for “Best of Power BI World…
Power BISync Slicers & Sync Slicers Advanced OptionsPower BI Bookmarks, Synced Slicers and Selections; these features transformed the way we report using Power BI. Now, most of the…
Power BISummary of #LondonPowerBIDataViz December 2018Happy New Year! Hope you all had a lovely time over Christmas and New Year period. My holiday started nicely with…
Power BIVisuals Level Slicers for A Slicer in #PowerBIIn my current project, one of the user requirement was to have a filter on the Year Slicer. To explain in…
Power BIDynamic Legend in #Power BI Visual, Line ChartIt has been a while since I written a blog post, even my ten years old daughter started teasing saying “Motionless blog”,…
Power BIOctober and November #LondonPUGDataViz – UK Price Paid DataMy Power BI journey started with this dataset. Probably one of the most reliable open data source. Nicely formatted and very…
Power BIPowerApps and Sharepoint List-Identify which detail item has already been updated in PowerApps?In one of my recent project, I did a fair bit of PowerApps. PowerApps was the front end, Share point list…
Power BIDynamic Period variance with DAX in #PowerBIOne of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once…
Power BIList.Repeat() in #PowerQuery to duplicate rowsAnother quick, more of “Note to self” blog post. While I was working with FIFA Football Model, one of the queries…
Power BIMass shooting dataFor this month #LondonPUGDataViz, we are going to play with Gun violence archive data. This data is very interesting because it…
Power BIAdding a vertical line or marker to a chart in Power BIA business user came to me asking “how can I get a vertical line on Line Chart in Power BI like…
Power BILondonPUGDataViz -2The dataset for the next LondonPUGDataViz is The Newyork time bestseller data from Wikipedia. It looks like only data between 2000 to…
- Power BILondonPugDataViz – 1
As some of you already know, we started #LondonPugDataViz at London Power BI User Group for completing two successful years. I am…
- Power BI#LondonPUGDataViz
With inspiration from many DataViz blogs, especially from Story Telling With Data and DataDuo, I thought to start #LondonPUGDataViz. Mainly to…
Power QueryReplace all numeric values in multiple columns using #PowerQueryLearn how to replace all numeric values in multiple Power Query columns at once. A practical M language solution for data transformation in Power BI.
Power BI#PowerBI Audit log using #Office365 Management APII love automating things, I have read somewhere, a good developer always tries to automate things, but in my case, I…
Power BIWhere is my Power BI theme file?Have you ever ended up in a situation where someone already did all the work to get the right brand colours,…
SQLSplit multiple columns into rows in #PowerQueryRecently, I worked on an interesting problem. Datasource I was working with was a SharePoint list, working with SharePoint lists always…
Power BIPower BI Template to document the Power BI ServiceBack in September, I promised I would write another blog post with a beautiful looking Power BI template. Even though I…
Power BIHow I designed “Power BI Template to document the Power BI Service”When it comes to writing, I have the least trust in my writing skills. I always wanted my blog to sound…
Power BIHow to find all Power BI users in an organisation?If you are the goto person for Power BI in your organisation, then I am sure at least once you may have…
REST APIAccess Microsoft Graph API using Power BIRecently I came across Microsoft Graph API through Power BI Custom data connectors documentation. Amazed by the amount of information provided…
Power BISharePoint List Power BI TemplateSharePoint is a killer; front end looks nice and beautiful. Once you start exploring behind the screens, that is when it…
Power BICalling Power BI API using Power BI Desktop to document Power BI Service(Ideally, I would like to do this as a Power BI custom data connector. I have tried, for some reason, my…
- Power BIDynamically update Offset value for API calls using Power BI / Power Query
If you are a Power BI user group organiser, then it’s kind of obligatory to create a Power BI dashboard on…
Power BIPower BI Workaround – Drill Through Reporting in Power BISo far I have seen many Power BI usage metrics demo’s or read blog posts about usage metrics, but not actually…
Power BIPower BI Workarounds – Clickable Card / Card Look-alikeRecently one of my business users came to me asking “how can I get a Clickable Card in Power BI”? He…
Power BIPowerBI Embedded with OneNoteI am a huge OneNote fangirl, most of the times I start my working day by opening OneNote. But yesterday I…
Power BIPASS BA Marathon – Compelling Visuals in Power BIIn my recent talk for PASS BA Marathon, I showed few formatting tricks in Power BI with my super slow laptop. I…
Power BIModify Column Names Using Power Query M FunctionsUpdate – There is already a dedicated function available to do this, Table.TransformColumnNames. Thanks Imke Feldmann for the shutout. You can…
Power BIHighlight a Specific Data Point using Power BIFor me, Stephen Few has always been the guru of Data visualisations. Recently, while I was reading one of his paper, I…
Power BIUK Power BI Summit – 2017UK Power BI summit was taken place on 16th – 17th of February at Hemel Hempstead, HERTS, UK. It was organised by…
Power BIFind level of Directories / Find String in Power BIDirectories at different levels are critical for some organisations. One of the requirements I received recently was to import Flat Files from directories (…
SQLValidating Data using SSISI cannot believe it took me almost three months to recover from the house move. At last, I feel like I…
Power BIData story – Property search with Power BIDon’t wait for the opportunity CREATE it. I was just trying to create an opportunity to work with Power BI; that…
Power BIDimensional Modelling WorkbookA few years ago when I was searching for a free dimensional modelling tool, through some forum; I saw this fantastic Dimensional…
SQLI am a Microsoft Data Platform MVP :)October 1st, 2016, 03:00 PM. I was in our car with my family on our way to Harveys and email notification…
Power BIHow to add extra columns to an existing Power BI file which has CSV as data sourceQuick Power BI Tip: Case: How to add extra / new columns to an existing Power BI file which has CSV as…
SQLMY THOUGHTS ON SSIS 2016 – SSIS PACKAGE PARTS-2This is the second part of SSIS Package Parts blog post, I would recommend you to read other part first! In the previous…
Power BIMy Thoughts On SSIS 2016: SSIS Control Flow Package Parts -1This blog post has become longer than I thought, so decided to post as two parts. First part covers introduction and…
Semantic LinkMy Thoughts On SSIS 2016SSIS has always been my favourite among all MSBI tools. I think it is ETL which interests me than specific SSIS.…
Power BIDownload And Unzip files using Power BI Desktop and R ScriptMost of the open data source providers supply data in a compressed format, especially when files are large. That is what…
SQLWorking With Teradata Volatile Tables And ADO.Net ConnectionWhile I am in the flow of blogging, I want to write about an issue which troubled me recently. It definitely…
SQLTwitter Analysis using SSIS 2016 and SQL Server R ServicesAfter years of hesitation finally, I think I am ready to write my first blog post, or I should say I…
Every post keeps the URL it was published at. Posts moved over from the previous site keep their original dates.