set_isavailableinmdx
Reduce Power BI memory and processing by setting IsAvailableInMDX false on non-attribute, high-cardinality columns, and protect sort integrity by keeping it true on sort columns.
Instructions
Set Column.IsAvailableInMDX. Setting it false on high-cardinality, non-attribute columns saves memory and processing. GUARD: it is kept TRUE on any SortByColumn target (flipping it false breaks the sort with 'invalid column ID'). Pass table+column for one column; pass table alone to set a whole table; or bulkHeuristic=hiddenAndKeys (with no table/column) for a safe model-wide pass over hidden/key columns.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | table (omit with bulkHeuristic for a model-wide pass) | |
| value | Yes | the value to set (false to disable MDX availability) | |
| column | No | column (omit to set the whole table) | |
| sessionId | Yes | ||
| bulkHeuristic | No | hiddenAndKeys for a model-wide pass over hidden/key columns |