Opens Premium, Premium Per User and Fabric semantic models to SSMS, Tabular Editor, DAX Studio and similar tools over XMLA. Read-only unless set to read-write per capacity, which also permits deployment and management.
Also called XML for Analysis.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains XMLA endpoint in context, with comparison tables and the common traps.
Terms in this definition
- Premium
Hosting plan for Azure Functions that keeps instances pre-warmed to avoid cold starts and supports VNet integration. Executions time out after 30 minutes by default, which host.json can extend.
- PPU
Premium Per User. Licensed person by person, it adds most Premium capacity features on top of everything Pro offers. Items in a PPU workspace are shareable only with other PPU licence holders, and no Fabric capacity comes with it.
- SSMS
SQL Server Management Studio, a tool for administering SQL Server, used for tasks such as building a target schema.
- DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- Set
Secret permission in Key Vault for writing secrets; some older material refers to it as Create.
- Capacity
A reserved block of compute for a tenant whose size is fixed by its SKU; Fabric F SKUs express it in capacity units (CUs). Workspaces assigned to it unlock features like Copilot, and from F64 upwards people with free licences can view Power BI content.
- Model deployment
Inside a resource, each deployment is a named copy of a Foundry model with its own TPM quota and deployment type. Requests identify the model by this deployment name.
Related terms
- ADOMD
The .NET client library for Analysis Services that tools use to run queries against a semantic model over the XMLA endpoint. Administrative work is left to its sibling library, AMO.
- ALM Toolkit
An open-source, no-cost utility for comparing Power BI semantic model schemas. Because it can release just the metadata changes you pick through the XMLA endpoint, a model that's already published keeps both its data and its incremental refresh partitions.
- Build permission
Allows a person to make new things on top of a semantic model: reports, Analyze in Excel sessions or XMLA endpoint queries, for example. Anyone with the Contributor workspace role or higher gets it without being granted it separately.
- EffectiveUserName
Set in a connection string, it lets you query through the XMLA endpoint as somebody else, which is useful when testing RLS. That person must hold both Build and Read on the semantic model.
- MSOLAP
Excel, SSMS and similar tools reach semantic models through the XMLA endpoint using Microsoft's native Analysis Services client library (alongside ADOMD.NET and AMO/TOM). Microsoft apps install and update it automatically.
- TOM
A .NET library that extends AMO and lets code create and manage tabular models, including their tables, columns, measures and roles, through the XMLA endpoint.