Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Get the date and time that measures, columns and other objects were last changed

A free CLI that checks your Dax Lib package structure, manifest fields and naming conventions before you open a pull request. Get it on GitHub.

A DAX UDF library for Six Sigma and SPC in Power BI: DPMO, Sigma Level, Cp/Cpk, Nelson Rules, tested on real GB grid frequency data. Free on GitHub.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

In Part 4 of this series, I used the Power BI report management and authoring skills to audit report themes across Fabric workspaces. The workflow worked, but it was not as smooth as I wanted it to be. We found the PBIR limitation, worked out a fallback for the legacy reports, and ended up with several prompts and instructions that I had to remember each time I ran the process.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

How I built a Power BI tool that scores colour contrast using APCA, a perceptual model, rather than WCAG ratios, plus a free downloadable template.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Learn how to implement source control for semantic models using Git, enhancing your Power BI CI/CD processes and simplifying change management.

Learn how to set up OneLake security in Microsoft Fabric so row level security flows automatically from lakehouse to semantic model to report.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

This post, the repo and every number in it are personal opinion. Nothing here is a Fabric position, benchmark or recommendation. My colleague Eiki published a post on Microsoft’s white p…

This patch release addresses several issues introduced or identified following the 3.6.0 release.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

A DAX calculation can produce convincing values at the detail level and still fail at the total. The problem is often not the total itself: the business rul

In almost a decade of building Power BI reports, a common blind spot I still see from colleagues regards data point limits in core visuals — largely unnoticed until someone maps their data and finds entire regions are missing. Compare the following lasagne plot created using a Power BI core visual scatterplot with one created… Continue reading A matter of scatter

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Will AI replace Power BI developers? No, but developers using AI will. Here is what actually changed, with real data.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

A blog about Qlik, Power BI, Tableau, ThoughtSpot, personal finance, food, podcasts, and other random interests.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

An optimisation has shipped in the Power BI semantic model engine that cuts the time spent preparing a query that uses calculation groups. It happens before any data is read, so it will not speed up your scans. Some models will barely notice. Models with several calculation groups that reference each other could see a lot. Here is what was happening, why it was written that way, and how to work out which camp you are in.

Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

Let’s talk about matrix totals in this episode of The Whiteboard! Special guest: the SQLBI Whiteboard! Learn abstract DAX concepts in a more interacti

Learn how to build a custom skill file that teaches Claude your Power BI development standards, naming conventions, measure tables, and display folders, so the same prompt produces results that follow your exact conventions automatically, while optimizing token usage.

This rabbit hole started with a simple observation: VertiPaq seemed to like parquet produced by delta-rs more than parquet produced by DuckDB — and that drove me nuts. delta-rs was at the time a ni…

In this conversation, I sit down with Rob Collie, former Microsoft employee, one of the early people behind Power Pivot, founder of P3 Adaptive and author of Fair Game, to talk about how AI is changing the world of Power BI, data analytics, business intelligence and data careers.

Learn how to unpivot wide monthly data into tidy tabular tables using Power Query in Excel. Includes date headers, totals cleanup, and PivotTable reporting.