Absence in a Rolling 10 Week Window

From September 2024, schools will need to be able to track the number of sessions (half days) of unauthorized absence in a rolling period of 10 school weeks. This period of 10 weeks can span holidays and academic years. The Department for Education is coming at this from the perspective of a threshold measure for […]

Education Data Modelling

A look at modelling data for Power BI in an education setting.

Low Code Power BI Rest API Logs (Synapse)

Introduction A key requirement for strong Power BI governance is being able to easily report on usage from logs. There are many ways of getting logs in Power BI and many blogs looking at the various options. My preference until recently was to use the Rest API via Powershell to download a log file each […]

Field Parameters in Tabular Editor

UPDATED WITH EXTRA REQUIRED STEPS The May 2022 release of Power BI brought an exciting feature that greatly enables self service BI. I’d highly recommend watching Wyn Hopkins: Field Parameters in Power BI giving a brief introduction. My organisations main models however are deployed straight from Tabular Editor via the XMLA end point. Therefore to […]

Calculation Groups and RLS

I had a specific requirement to be able to show summary data for a whole organisation ignoring any RLS while being able to slice by all attributes. At the same time I needed to only show data attributed to names, for particular groups defined by RLS. There are many approaches to doing this. One I’d […]

SUMMARIZECOLUMNS and Filters

This blog post originated from a question in the Power BI Community forum. The final solution is very straight forward but my aim is to illustrate an underlying behaviour in Power BI with a simple example. The problem can be seen in this pbix file. We have a basic data model: With the following two […]