The Power BI XMLA Adapter models dimensions as tables, cubes as schemas, and a combination of the Workspace and DataSet Catalog as the Catalog. Live connectivity to these objects means any changes to your Power BI XMLA account are immediately reflected when using the adapter.

Notes:

• You can connect the adapter to multiple Workspaces simultaneously 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.

• The adapter models Power BI XMLA entities like documents, folders, and groups as relational views, which allows you to write SQL to query Power BI XMLA data.

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 that 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 actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including downloading documents and moving envelopes.