Free sections from Ultra Transcenders PL-300: Microsoft Power BI Data Analyst, on the comparisons and decisions the exam keeps asking about.
How a referenced query differs from a duplicated one, and what each choice means for refresh, maintenance and query dependencies.
Where to change a source's credentials and path, and how None, Private, Organizational and Public privacy levels affect combining data.
How to filter one fact table by the same dimension in several roles, such as order date and ship date, with inactive relationships or copies of the table.
How CALCULATE changes filter context and when to use ALL, REMOVEFILTERS, KEEPFILTERS, USERELATIONSHIP and other modifiers.
How to report stock levels and account balances that sum across categories but not over time, using LASTDATE, LASTNONBLANK and closing-balance functions.
Which way of getting reports to readers fits each audience, licence and security need.
Which sources, storage modes and refresh scenarios need an on-premises data gateway and which connect directly from the cloud.
How to define static and dynamic row-level security roles in Power BI Desktop with DAX filters and USERPRINCIPALNAME.