Tagged
intermediate
5 documents tagged with "intermediate"
docs
Data Modeling with AggieDB
Star schema best practices, conformed dimensions, relationship rules, and why bidirectional filters are dangerous.
docsDAX Patterns for AggieDB
Common DAX measures and patterns used across AggieDB semantic models — fiscal year calculations, SWITCH, CALCULATE, RLS, and percentage measures.
docsDirectLake vs Import vs DirectQuery
Understanding Power BI's three query modes — when to use each, performance tradeoffs, how to detect fallback, and why DirectLake is the default in Fabric.
docsReport Distribution & App Management
How to get reports in front of 800 users — Power BI Apps, audience targeting, subscriptions, embedding, and what NOT to do.
docsRow-Level Security (RLS) Step-by-Step
Build RLS from scratch — create the security table, write the DAX role, test with different identities, and deploy to production.