Exports, from the Power BI service, a visual's data together with related semantic model data that isn't hidden, all unaggregated. It may require Build permission, and tenant or report settings can switch it off.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Underlying data in context, with comparison tables and the common traps.
Terms in this definition
- Power BI service
Power BI's browser-based SaaS component: people publish and share reports and semantic models there, create dashboards and apps, and set up scheduled data refreshes.
- RELATED
Fetches a column value from the lookup table, that is the one side of a many-to-one relationship, for whichever row is being evaluated. It therefore needs to run inside an iterator or a calculated column, where row context exists.
- 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.
- ALL
A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.
- 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.
- Tenant
A trusted, dedicated Microsoft Entra ID instance that stores the users, groups and app registrations of one organisation. A subscription trusts only a single tenant, although a tenant can be trusted by several subscriptions.
- SWITCH
Checks one expression against several candidate values, returning whichever result pairs with the match (or a fallback otherwise). Writing SWITCH ( TRUE (), ... ) avoids nested IF chains: whichever condition is first true wins.
Related terms
- Export data
An option on a visual for downloading its data to Excel or .csv, either as summarised data or, for users with Build permission, as underlying data. What is permitted depends on report and tenant settings, and tenant settings win where they conflict.
- Smart narrative
Generates written commentary on trends and key points in a Power BI report or one of its visuals, rewriting itself whenever the underlying data changes.