Free datasets for Power BI & Fabric practice
Star-schemas, sales, HR, RLS samples and more — curated so you can focus on learning DAX, modeling, Power Query and Fabric instead of hunting for data.
Retail Star Schema — CSV pack
A clean gold-layer star schema — one FactSales with foreign keys to six dimensions (Customer, Product, Store, Date, Order Type, Payment Method). Drop straight into Power BI or a Fabric lakehouse.
Retail Star Schema — single Excel
Same star schema as the CSV pack, bundled into one Excel workbook with a sheet per table. Use this if you prefer a single file over multiple CSVs.
Large file (~106 MB). If the download fails, use the CSV pack above.
Actual vs Target
Sample actual and target values — perfect for practicing MTD comparisons, distributing a monthly target across daily buckets and building target-vs-achievement dashboards.
HR Data with Department
Employee records with hire & termination dates plus department mapping. Great for practicing hires, terminations, current headcount, tenure and attrition — same pattern works for active-project analysis.
P&L Statement Data
Chart-of-account-style data ready for building a Profit & Loss statement. Practice hierarchical financial reporting, subtotals and calculation groups.
Transformations Playground
Multiple sheets, each showing a different transformation challenge — pivot / unpivot, split, merge, group, fill down, custom columns. Perfect for practicing Power Query (M) and Dataflows.
Retail Sales — single table
One denormalized table containing orders, items, customers and stores. Great for straight-up Power BI analysis, and for splitting into a proper star schema using Power Query or Fabric.
Retail Sales — Fabric column names
Same data as above but with snake_case column names (no spaces, no special characters) — better for Fabric Lakehouse tables and Spark / SQL work.
Dynamic RLS — Brand Test
User–brand mapping designed for learning Dynamic Row-Level Security in Power BI. Assign different brand access per user and validate with USERPRINCIPALNAME().
Sales Data (from videos)
The star-schema-style sales dataset used across the YouTube tutorials — small enough to iterate quickly. For a much larger, cleaner star schema, prefer the Retail Star Schema packs above.
Sales Data for Fabric
Same as the video sales dataset, but with Fabric-friendly column names (no spaces or special characters) — ready for Lakehouse ingestion.
Sales Data with Transformations
📝 Assignment write-up →A modified version of the sales data that intentionally requires clean-up before use — fill up / fill down, custom Item dimension and other Power Query steps. Compare your final Item dim against the reference.
Need more? Get every dataset on GitHub.
The full collection — with every raw file, sample dashboards and additional practice sets — lives on GitHub. Most tutorials on my YouTube channel use these exact files.