create_date_table
Create a complete Power BI date table in one call, including year, quarter, month, and hierarchy. Size it to your fact dates or generate offline PBIP TMDL.
Instructions
Create a fully-formed date table in ONE call: Date, Year, Quarter, Month, MonthYear + sort-by columns + a Year>Quarter>Month hierarchy. Then relate your fact's date column to [Date]. Pass dateColumnRef (e.g. "Fact[Date]") to size the range to your data, else CALENDARAUTO() is used. target=pbip: pass pbipFolder instead of sessionId to write the SAME table as Desktop-faithful TMDL into a PBIP semantic model with NO engine (columns authored explicitly; data materialises on the first Desktop refresh).
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | table name, e.g. Calendar | Calendar |
| hierarchy | No | also build a Year>Quarter>Month hierarchy | |
| sessionId | No | sessionId from connect_model (live engine; pass exactly one of sessionId / pbipFolder) | |
| pbipFolder | No | target=pbip: a PBIP <name>.SemanticModel / TMDL definition folder to edit OFFLINE (engine-free) | |
| dateColumnRef | No | date column to size the range, e.g. Fact_Sales[Week Ending] (optional) |