Change password expiration policies for service accounts in O365

Something I come across quite often while helping customers implement cloud-based BI environments, is the configuration of service accounts for things like ETL processes, Power BI data refreshes, etc. In O365 (or Azure AD) the default behavior to set password expiration policies is at an organizational level. I’m pretty far from being an Active Directory …

Continue reading

A user-friendly way to deal with role-playing dimensions in Power BI

Role-playing dimensions present some interesting challenges for modeling & reporting in Power BI (and SSAS Tabular for that matter), but also some opportunities to think outside the box and create more intuitive solutions. What are role-playing dimensions? In technical terms a role-playing dimension is when a dimension table has multiple (foreign key) relationships to the …

Continue reading

Similarities between consulting and rugby

Growing up in South Africa, rugby was a big part of our culture and my own upbringing. Every schoolboy’s dream was to play professional rugby one day and not a day went by without playing rugby, watching rugby or planning to do one of those two things. Fast forward 30 years and I am too …

Continue reading