AtScale cubes

This reference describes the AtScale cubes connector metadata and supported capabilities, including connection parameters.

Summary

Property Value
Connector AtScale cubes icon AtScale cubes
Products Power BI (semantic models)
Power Query Online
Release state General availability
Category Database
Authentication kinds AtScale
Data source kind AtScale
Function Reference Documentation AtScale.Cubes
Support link Support

Supported capabilities

  • Import
  • DirectQuery

Parameters

Entry point: AtScale.Cubes

Required parameter count: 1

Import/DirectQuery cube data from an AtScale.

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...].
Parameter Display name Required Type Group Description Sample values Nullable Additional metadata
server Server Yes text Specify the AtScale server URL "https://contoso.atscale.com:10502/xmla/..." false {"Documentation.Category": "", "Documentation.Examples": [], "Documentation.LongDescription": "The type that represents a text URI.", "Documentation.Name": "Uri.Type", "Documentation.Description": "The type that represents a text URI."}
options Options No nullable record Options Specify the options to connect to AtScale server true

Fields in options

Field Required Type Group Nullable Optional
options.ConnectionTimeout No nullable duration Options true true
options.CommandTimeout No nullable duration Options true true