power-bi-modelinglisted

# power-bi-modeling Data modelling: star schema design, source profiling, partitions, incremental refresh, calendar generation, and locale settings. ## Quick Reference ```bash # Model inspection pbi model info pbi model tables pbi model columns --table Sales pbi model relationships pbi model lint pbi model suggest-measures pbi model lineage --format mermaid # Source profiling and scaffolding pbi source profile --type sql --conn "Server=prod;Database=SalesDW;" --output profile.json pbi source profile --type excel --file ./data/source.xlsx --output profile.json pbi source profile --type rest --url https://api.example.com/sales --output profile.json pbi source scaffold --profile profile.json pbi source scaffold --profile profile.json --apply # write directly to open model pbi source suggest-joins --profiles fact.json,dim.json # Partition management pbi partition list --table Sales pbi partition add --table Sales --name "Sales_2025" --filter "Year = 2025" pbi partition refresh --table Sales --name "Sales_2025" pbi partition delete --table Sales --name "Sales_2024" # Incremental refresh pbi partition incremental --table Sales \ --range-start 2020-01-01 --range-end TODAY \ --incremental-window 30d --full-window 3y # Calendar table pbi calendar create --start 2020-01-01 --end 2027-12-31 --table-name Calendar pbi calendar create --fiscal-year-end 06-30 # June fiscal year pbi calendar mark-as-date-table --table Calendar --date-column Date # Locale / culture pbi cultu