My journey from Datum to Data
Real-world Power BI techniques, written down as I figure them out. DAX, M, and the sharp edges nobody warns you about.
The posts, by topic
Five things I kept coming back to. Each card links straight to the full write-up.
01 / Scripting
PowerShell
Automating the boring parts of the workflow. Scripts that fetch, refresh, and tidy up so I don’t have to click through the portal every morning.
02 / Modeling
Date Dimension
Every model needs one, and everyone builds it differently. Here’s my go-to calendar table in DAX and M, plus the columns you’ll actually use.
03 / Security
USERNAME()
Row-level security starts here. How USERNAME() and USERPRINCIPALNAME() behave in the service versus the desktop, and the trap that catches everyone.
04 / Sources
SharePoint & OneDrive
Pulling files from SharePoint and OneDrive without the connector fighting back. Folder paths, authentication, and keeping refreshes stable in the service.
05 / Visuals
Histogram
Power BI has no native histogram, so you build one. Dynamic bins, grouping columns, and a measure that reacts as your data shifts.
What’s next
The road leads to Fabric
Everything I learned wrangling Power BI is now feeding into Microsoft Fabric. Same journey from datum to data — bigger canvas. Follow along as I dig in.