Overview

This section shows the available API objects and provides more information on executing SQL to Power BI XMLA APIs.

The adapter models dimensions as tables, cubes as schemas, and a combination of the Workspace and DataSet Catalog as the Catalog. The adapter supports connecting to multiple workspaces at the same time by supplying a comma-separated list of workspaces in the Workspace property. The result is that each workspace shows up in the catalogs as WorkspaceName_CatalogName.

Key Features

• The adapter models Power BI XMLA entities like documents, folders, and groups as relational views, allowing you to write SQL to query Power BI XMLA data.
• Stored procedures allow you to execute operations to Power BI XMLA.
• Live connectivity to these objects means any changes to your Power BI XMLA account are immediately reflected when using the adapter.

Measure Attributes

By default, all measure attributes are listed in a 'Measures' view. However, you can set SplitMeasures to 'true' to split the measures view; the result is each measure attribute is included in its respective view based on the Measure Group value. Further classification based on 'Measure Directories' is not included.

Stored Procedures

Stored Procedures are function-like interfaces to Power BI XMLA. Stored procedures allow you to execute operations to Power BI XMLA, including downloading documents and moving envelopes.