Gyromitra
Power BI Blog
Practical guides on Power BI, DAX, data modeling, and the PL-300 certification — written by a Microsoft Certified Trainer.
Drillthrough and Cross-Report Drillthrough in Power BI, Explained
Drillthrough lets users jump from a summary visual to a detail page filtered to exactly what they clicked. Here's how it works, how cross-report drillthrough extends it, and where PL-300 tests the difference.
Query Folding in Power BI: Why Some Refreshes Are Fast and Some Aren't
Query folding pushes Power Query steps back to the data source instead of running them locally. How to spot it, what breaks it, and why PL-300 asks about it.
Calculation Groups: The Advanced DAX Feature Worth Learning
Calculation groups replace dozens of duplicate time-intelligence measures with one reusable set. What they are, how SELECTEDMEASURE() works, and why PL-300 candidates should know them.
Power BI DirectQuery vs Import: How to Choose (and What PL-300 Asks)
DirectQuery and Import trade off freshness against speed and DAX support. Here's how to choose a storage mode, and how PL-300 scenario questions test the decision.
Cross-Filter Direction in Power BI: When Bidirectional Helps and When It Hurts
Bidirectional relationships look like a quick fix for a filter that "isn't working," but they add ambiguity and slow refreshes. Here's how cross-filter direction really works — and what PL-300 expects you to know.
Power Query M: The 10 Transformations You Must Know for PL-300
The "Prepare the data" domain hinges on Power Query. Here are the ten M transformations that show up most in PL-300 — what they do, why they exist, and how the exam likes to test them.
Star Schema vs Flat Table: Why PL-300 Tests This So Heavily
A flat table feels simpler, but it quietly breaks DAX, bloats your model, and costs you marks on PL-300. Here's what a star schema actually buys you, and how to spot the exam's favorite modeling trap.
Row-Level Security in Power BI: Static vs Dynamic, With a Walkthrough
RLS shows up in both the modeling and deployment domains of PL-300. Here's how static and dynamic row-level security actually work, with a walkthrough you can rebuild yourself.
Common DAX Mistakes: SUM vs SUMX, and When Each Is Right
SUM and SUMX look interchangeable until they aren't. A practical guide to when a plain aggregation works, when you need an iterator, and the row-level calculation mistake that costs candidates marks on PL-300.
Time Intelligence in DAX: YTD, MTD, Prior-Year, and Rolling Averages
A practical walkthrough of the DAX time intelligence functions PL-300 tests most — year-to-date, month-to-date, same-period-last-year, and rolling averages — and the date table rules that make them work.
Row Context vs Filter Context: The DAX Concept Most Candidates Fail
Row context and filter context look similar and behave completely differently. Here's how to tell them apart, why calculated columns and measures don't mix the way people expect, and what PL-300 tests.
How to Build a Proper Date Table in Power BI (PL-300 Guide)
Auto Date/Time silently breaks time intelligence and bloats your model. Here's how to build a real date table, mark it correctly, and why PL-300 expects you to know the difference.
DAX CALCULATE Explained: 3 Worked Examples for PL-300
CALCULATE is the function most PL-300 candidates never fully understand. Three real worked examples — filter overrides, percent-of-total, and context transition — explained step by step.
PL-300 Pass Rate & Exam Difficulty: What the Data Shows
How hard is the PL-300 Power BI exam? We break down the pass rate, difficulty by domain, and what it actually takes to pass on your first attempt — from a Microsoft Certified Trainer.
Power BI Certification Cost in Canada (2026): PL-300 Exam & Training Fees
Complete breakdown of what you'll actually spend to get PL-300 certified in Canada — exam fees, training options, employer reimbursement, and how to minimise your total investment.
PL-300 Exam Questions: 25 Free Practice Questions with Answers
Practice for the PL-300 Power BI exam with 25 free exam-style questions covering all four domains. Instant scoring, per-question explanations, and a domain breakdown.
Is the PL-300 Certification Worth It in 2026?
An honest look at the PL-300's career value: salary data, job market demand in Canada, who benefits most, and who should probably skip it.
Power BI vs Tableau: Which Is Better for Canadian Professionals in 2026?
Job market data, cost comparison, M365 integration, and an honest verdict on which tool — and which certification — will open more doors in Canada.
The Complete PL-300 Study Guide: How to Pass the Power BI Data Analyst Exam
Everything you need to know to prepare for and pass the Microsoft PL-300 exam — exam format, topic breakdown, study timeline, and the resources that actually work.
Learn Power BI with a live instructor
Reading can only take you so far. Our 8-week live course gets you PL-300 certified with a Microsoft Certified Trainer.