Cube.Dimensions

Updated on

Cube.Dimensions is a function in the Power Query M language that returns a table containing the set of available dimensions within a cube. The function returns a table with each dimension represented by a table of dimension attributes, which can be expanded using Cube.AddAndExpandDimensionColumn.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Cube.Dimensions( cube as table ) as table

Description

Returns a table containing the set of available dimensions within the cube. Each dimension is a table containing a set of dimension attributes and each dimension attribute is represented as a column in the dimension table. Dimensions can be expanded in the cube using Cube.AddAndExpandDimensionColumn.

Other functions related to Cube.Dimensions are:

BI Gorilla Blog

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/cube-dimensions