A way to explore a published semantic model from Excel: the service produces a workbook connected live to the model, so PivotTables send MDX queries to it. Users need Build permission on the model.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Analyze in Excel in context, with comparison tables and the common traps.
Terms in this definition
- Semantic model
Sometimes called an OLAP model, this Power BI and Fabric layer defines the measures, hierarchies, tables and relationships that reports and dashboards query; star schema design is the usual pattern.
- Workbook
An interactive report in Azure Monitor that brings together text, metrics and logs.
- MDX
The query language that clients like Excel PivotTables, including Analyze in Excel, send to Analysis Services models. Because MDX can't aggregate columns implicitly, such clients rely on explicit measures.
- 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.