AtScale.Cubes

Updated on

AtScale.Cubes is a Power Query M function that imports and/or directly queries cube data from an AtScale server with customizable options for typed measure columns, command timeout, and connection timeout.

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

Syntax

AtScale.Cubes(
   server as text,
   optional options as nullable record,
) as table

Description

Returns cube data from AtScale on server server. An optional record parameter, options, may be specified to control the following options:

  • TypedMeasureColumns: A logical value indicating if the types specified in the multidimensional or tabular model will be used for the types of the added measure columns. When set to false, the type “number” will be used for all measure columns. The default value for this option is false.
  • CommandTimeout: A duration (in seconds) which controls how long the server-side query is allowed to run before it is canceled. The default value is driver-dependent.
  • ConnectionTimeout: A duration (in seconds) which controls how long to wait before abandoning an attempt to make a connection to the server. The default value is driver-dependent.
The record parameter is specified as [option1 = value1, option2 = value2…].

Examples

List the cube data in an AtScale cube.

AtScale.Cubes( "https://contoso.atscale.com:10502/xmla/..." )

Contribute » | Contributors: Rick de Groot