SapBusinessWarehouse.Cubes is a Power Query M function that returns a table of InfoCubes and queries from an SAP Business Warehouse instance. The function returns a table of InfoCubes and queries grouped by InfoArea.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
SapBusinessWarehouse.Cubes(
server as text,
systemNumberOrSystemId as text,
clientId as text,
optional optionsOrLogonGroup as any,
optional options as nullable record,
) as tableDescription
Returns a table of InfoCubes and queries grouped by InfoArea from an SAP Business Warehouse instance at server server with system number systemNumberOrSystemId and Client ID clientId. An optional record parameter, optionsOrLogonGroup, may be specified to control the following options:
