Categories
Fabric Power BI

Intentional Header Behaviour in Paginated Reports

If you’ve tried to get header rows to repeat or scroll as you move through your paginated reports, you may have felt the frustration of getting them working correctly. Whether it’s Reporting Services, Power BI, or Fabric, the flavour doesn’t matter. The properties on the tablix should provide the functionality, but they’re not reliable. In this post […]

Categories
T-SQL Tuesday

T-SQL Tuesday #194 – Learning from Mistakes

Part of the joy of new experiences is making mistakes and learning from them. For this month’s invitation, Louis Davidson asks us to share one of those mistakes to help others learn. The lesson I learned: don’t let order become meaning TL;DR: Don’t reuse numeric sequences for things they’re not designed for. With the prevalence of identity columns on tables, it […]

Categories
Fabric Power BI

Elevate Report Presentation with Apps in Power BI and Fabric

When using Power BI or Fabric workspaces to browse reports, we’re greeted with a list of items and their attributes. While attention is given to report visuals such as bars, pies, candles, and RAG highlights, the surrounding experience is neglected. When it comes to consumption, the standard interface falls short. Apps fill this gap. They’ve […]

Categories
Personal

A Two-Year Review (2024-2025)

January is a great time of year to raise your head and take a look around. Looking back at what has been, where we’re going, and the technical and mental debt which needs a clear out. I skipped this Year in Review last year due to other commitments, so there’s a little more ground to […]