Lantern Tools

AdventureWorks' Power BI model, drawn

JOINED TO NOTHING — OR ONLY TO EACH OTHER 0 joins out 1 join out 2 joins out Product[Category] → Table[Category] Sales[SalesTerritoryKey] → Sales Territory[SalesTerritoryKey] Sales[ProductKey] → Product[ProductKey] Sales[ResellerKey] → Reseller[ResellerKey] Sales[OrderDateKey] → Date[DateKey] Sales[DueDateKey] → Date[DateKey] Sales[ShipDateKey] → Date[DateKey] Date[Date] → LocalDateTable_1635aca9-f5cf-4673-8bd0-6cbe59eca959[Date] Date[Month] → LocalDateTable_d1146ef7-6f90-4647-b97e-2ffae90ba854[Date] Date[Full Date] → LocalDateTable_dc06deb5-c3da-486c-acde-3111d75ed696[Date] Sales[CustomerKey] → Customer[CustomerKey] Sales Order[SalesOrderLineKey] → Sales[SalesOrderLineKey] Sales Sales Sales Order Sales Order Customer Customer Date Date LocalDateTable_dc06deb5-c3da-486c-acde-3111d75ed696 LocalDateTable_dc06deb5-c3da-486c-acde-3111d75ed696 LocalDateTable_1635aca9-f5cf-4673-8bd0-6cbe59eca959 LocalDateTable_1635aca9-f5cf-4673-8bd0-6cbe59eca959 LocalDateTable_d1146ef7-6f90-4647-b97e-2ffae90ba854 LocalDateTable_d1146ef7-6f90-4647-b97e-2ffae90ba854 Reseller Reseller Product Product Table Table Sales Territory Sales Territory DateTableTemplate_788642c5-9a9d-4431-b350-9f47f7e53393 DateTableTemplate_788642c5-9a9d-4431-b350-9f47f7e53393 Sales Amount by Due Date HOW TO READ ME1 join outa freckle = a measure · the grey tail = its copiesfact tables sit on the middle disca dot = a tablea rope = a join · the thick end is the many sideeach ring out = one more join awayHover anything: it tells you its name.Click a dot: its related tables and measures light up, everything else steps back. Ctrl-click adds.HOW BIGsmallbigstored data · the bigger, the palerHOW THICKfewmanykey values crossing the joinTHE ROPESa join · thick end = the many sidekeys find nothingflows both waysswitched offA DOT'S COLOUR — WHERE ITS TABLE COMES FROMa databasecomputed from other tablestyped in by handa calculation groupa field parametersource unresolvedWHAT GREW ON ITbarnacles = Power Query steps past the basic twothorns = calculated columns, one spike eachan inner ring = incremental refreshThe side lists hold the tables joined to nothing.lanternbi.com · drawn 2026-10-13

12 tables · 12 joins · 1 measures · 3 MB stored

Open in the toolDraw your own model

AdventureWorks is Microsoft's bicycle company demo, here in its Power BI Desktop sales version. The sample .pbix is a public download.

What the drawing shows

Where to get the sample

Microsoft'spowerbi-desktop-samples repository on GitHub, the AdventureWorks Sales file. Export the two files with the steps on this site, or click the AdventureWorks disc on the landing page.

Draw your model