Index
A
- Active Directory (AD) / Report server administration, Implementing data governance
- Add Column From Examples / Add Column From Examples
- age calculation / Age calculation
- Analysis Services
- about / Analysis Services
- versus Power BI Desktop / Analysis Services Models versus Power BI Desktop
- scale / Scale
- usability / Usability
- development and management tools / Development and management tools
- versus SSAS / Azure Analysis Services versus SSAS
- SSAS, migrating / SSAS to Azure AS Migration
- Provision Azure Analysis Services / Provision Azure Analysis Services
- Power BI Desktop, migration / Migration of Power BI Desktop to Analysis Services
- Analysis Services models
- Live connection / Live connections to Analysis Services models
- Azure Analysis Services / Azure Analysis Services refresh
- Analytics pane
- about / Analytics pane
- Trend Line / Trend Line
- forecast line / Forecast line
- Analyze in Excel / Analyze in Excel
- animation / Animation and data storytelling
- Appending Queries / Appending Queries
- application lifecycle management (ALM) / Version control
- application workspaces
- about / Application workspaces
- rights / Workspace roles and rights
- roles / Workspace roles and rights
- admins / Workspace admins
- members / Workspace members
- My Workspace / My Workspace
- ArcGIS Map visual / The ArcGIS Map visual
- about / ArcGIS Map visual for Power BI
- ArcGIS Maps Plus subscriptions / ArcGIS Maps Plus subscriptions
- Area charts / Line and Area charts
- audit logs
- about / Audit logs
- monitoring solutions / Audit log monitoring solutions
- solution template / Audit logs solution template
- Azure Active Directory (AAD)
- about / App deployment process, Implementing data governance, Azure Active Directory
- B2B collaboration / Azure AD B2B collaboration
- conditional access policies / Conditional access policies
- Azure Active Directory Privileged Identity Management (PIM) / Power BI licenses
- Azure Analysis Services (AAS) / Dataset-to-workspace relationship, Premium capacity estimations, Analysis Services
- Azure Data Lake Store (ADLS) / Azure Analysis Services versus SSAS
B
- bar charts / Bar and Column charts
- base measures
- about / Base measures
- measure support expressions / Measure support expressions
- bookmarks
- about / Bookmarks
- selection pane / Selection pane and the Spotlight property
- spotlight property / Selection pane and the Spotlight property
- custom report navigation / Custom report navigation
- view mode / View mode
- Bridge Table Queries / Bridge Tables Queries
- bubble map / Bubble map
- business-to-business (B2B) collaboration
- about / Azure AD B2B collaboration
- external users, licensing / Licensing external users
C
- CALCULATE() function
- about / The CALCULATE() function
- related tables / Related tables
- FILTER() function / The FILTER() function
- calculated columns
- building / Building calculated columns
- string functions / String functions – Month, Year
- format function / Format function – Month Year
- age calculation / Age calculation
- SWITCH function / SWITCH() – age breakdown
- navigation functions / Navigation functions – RELATED
- calculated measure
- about / Calculated measures – the basics
- Total Sales, creating / Total Sales
- Total Cost, creating / Total Cost
- Profit, creating / Profit
- Profit Margin, creating / Profit Margin
- filter context / Filter context
- categorical data
- visualizing / Visualizing categorical data
- bar charts / Bar and Column charts
- column charts / Bar and Column charts
- pie charts / Pie and Donut charts
- Donut charts / Pie and Donut charts
- Treemap visual / The Treemap visual
- Scatter chart / The Scatter chart
- Change Type / Change type
- chart
- versus tables / Tables versus charts
- selection / Chart selection
- Chiclet Slicer / Chiclet Slicer
- column charts / Bar and Column charts
- column metadata
- about / Column metadata
- Default Summarization / Default Summarization
- data format / Data format
- data category / Data category
- Combo charts / Combo charts
- comma-separated value (CSV) / Audit logs
- complex relationships
- working with / Working with complex relationships
- many-to-many relationships / Many-to-many relationships
- role-playing tables / Role-playing tables
- conditional access policies, AAD / Conditional access policies
- Conditional Columns / Conditional Columns
- content distribution methods / Content distribution methods
- Coordinated Universal Time (UTC) / Parameter Tables, Audit logs
- Corporate BI Capacity / Corporate and Self-Service BI capacity
- Corporate Power BI datasets
- about / Corporate Power BI datasets
- limitations / Limitation of Corporate BI datasets – Reusability
- custom application embedding / Custom application embedding
- custom report navigation / Custom report navigation
- custom visuals
- about / Custom visuals
- adding / Adding a custom visual
- Power KPI visual / Power KPI visual
- Chiclet Slicer / Chiclet Slicer
- Impact Bubble Chart / Impact Bubble Chart
- pulse chart / Pulse Chart
D
- dashboard data classifications / Dashboard data classifications, Gateway security
- dashboards
- interacting with / Creating and interacting with dashboards
- creating / Creating your first dashboard
- data, questioning / Asking your dashboard a question
- subscribing / Subscribing to reports and dashboards
- reports, subscribing / Subscribing to reports and dashboards
- sharing / Sharing your dashboards, Sharing dashboards and reports
- workspaces / Workspaces
- versus reports / Dashboards versus reports
- dashboard tiles
- about / Dashboard tiles
- details links / Tile details and custom links
- custom links / Tile details and custom links
- text boxes / Images and text boxes
- images / Images and text boxes
- SQL Server Reporting Services / SQL Server Reporting Services
- DMVs, querying from Power BI / SQL Server Reporting Services
- excel workbooks / Excel workbooks
- Excel workbooks / Excel workbooks
- cache, refreshing / Dashboard cache refresh
- data
- importing / Importing data
- connection methods, selecting / Which should I choose?
- data alerts
- about / Data alerts
- Microsoft Flow integration / Microsoft Flow integration
- Data Analysis Expressions (DAX) / Dataset layers
- data governance
- about / Data governance for Power BI
- implementing / Implementing data governance
- data import
- about / Importing data
- Excel, using as source / Excel as a source
- SQL Server, using as source / SQL Server as a source
- Web, using as source / Web as a source
- Data Model
- about / The Data Model
- Relationships View / The Relationships View
- Data View / The Data View
- Report View / The Report View
- fact tables / Fact tables
- bridge tables / Bridge tables
- data profiling / Data profiling
- dataset design process
- about / Dataset design process
- business process, selecting / Selecting the business process
- grain, declaring / Declaring the grain
- dimensions, identifying / Identifying the dimensions
- facts, defining / Defining the facts
- dataset layers
- about / Dataset layers
- dataset objectives / Dataset objectives
- objectives, competing / Competing objectives
- external factors / External factors
- dataset planning
- about / Dataset planning
- data transformations / Data transformations
- DATASETS / DATASETS
- data sources
- about / Data sources
- authentication / Authentication
- settings / Data source settings
- privacy levels / Privacy levels
- Power BI, using / Power BI as a data source
- Power BI Desktop options / Power BI Desktop options
- global options / Global options
- CURRENT FILE options / CURRENT FILE options
- data storytelling
- about / Animation and data storytelling
- play axis, for scatter charts / Play axis for scatter charts
- data transformation
- options / Advanced data transformation options
- Conditional Columns / Conditional Columns
- Fill Down / Fill Down
- Unpivot / Unpivot
- Merging Queries / Merging Queries
- Appending Queries / Appending Queries
- data visualization
- basics / Data visualization basics
- tips and tricks / Data visualization tips and tricks
- interactions, editing / Edit interactions
- Top N filter / The Top N filter
- Show Value as / Show value as
- data warehouse bus matrix / Data warehouse bus matrix
- date intelligence metrics
- about / Date intelligence metrics
- current year measure / Current versus prior and growth rates
- prior year measure / Current versus prior and growth rates
- growth percentage measures / Current versus prior and growth rates
- rolling periods / Rolling periods
- DAX, using as query language
- DAX measures
- about / DAX measures
- measure evaluation process / Measure evaluation process
- row context / Row context
- scalar function / Scalar and table functions
- table function / Scalar and table functions
- CALCULATE() function / The CALCULATE() function
- DAX variables / DAX variables
- DAX Studio
- about / DAX Studio
- Power BI dataset, tracing / Tracing a Power BI dataset via DAX Studio
- dimension metrics
- about / Dimension metrics
- missing dimensions / Missing dimensions
- DirectQuery
- about / DirectQuery
- limitations / Limitations
- DirectQuery datasets
- about / DirectQuery , DirectQuery datasets
- optimized DAX functions / Optimized DAX functions
- columnstore / Columnstore and HTAP
- HTAP / Columnstore and HTAP
- single sign-on, via Kerberos / Single sign-on to DirectQuery sources via Kerberos
- DirectQuery mode
- about / DirectQuery mode
- Donut charts / Pie and Donut charts
- Dot Plot by Maq Software / Dot Plot by Maq Software
- drillthrough report pages
- about / Drillthrough report pages
- custom labels / Custom labels and the back button
- back button / Custom labels and the back button
- multi-column drillthrough / Multi-column drillthrough
- Dynamic Management Views (DMVs) / The Report View, Field descriptions, Metadata management
- dynamic row-level security (DRLS) / Dynamic row-level security
E
- Email Subscriptions / Email Subscriptions
- Enterprise Mobility and Security (EMS) / Conditional access policies
- environment, installation
- about / Installation
- hardware, requisites / Hardware and software requirements
- software, requisites / Hardware and software requirements
- Analysis Services Integrated / Analysis Services Integrated
- Report Server product key, retrieving / Retrieve the Report Server product key
- SQL Server Reporting Services, migrating from / Migrating from SQL Server Reporting Services
- Excel
- using, for data import / Excel as a source
- Excel workbooks / Excel workbooks
- extract-load-transform (ELT) / Data transformations, PowerShell sample scripts, Audit log monitoring solutions
- extract-transform-load (ETL) / SQL views versus M queries, Uniqueness , PowerShell sample scripts, Data governance for Power BI, Audit log monitoring solutions, Azure Analysis Services versus SSAS
F
- fact tables
- about / Fact tables
- columns / Fact table columns
- column data types / Fact column data types
- fact-to-dimension relationships / Fact-to-dimension relationships
- Fill Down / Fill Down
- filled map / Filled map
- Filled Map visual / The Filled Map visual
- filter context
- about / Filter context
- CALCULATE function / Calculate
- percent of total calculation / Percentage of total calculation
- time intelligence / Time intelligence
- filtering
- visuals / Visuals for filtering
- Forecast line / Forecast line
- format function / Format function – Month Year
- Funnel Chart / The Funnel Chart
G
- gateway architectures / Gateway architectures
- gateway clusters
- about / Gateway clusters
- managing / Managing gateway clusters
- gateway administrators / Gateway administrators
- data sources / Gateway data sources and users
- users / Gateway data sources and users
- PowerShell support / PowerShell support for gateway clusters
- gateway security / Gateway security
- Gauge visual / The Gauge visual
- generally available (GA) / On-premises data gateway planning, Parity with SQL Server Reporting Services
- geographical data
- visualizing / Visualizing geographical data
- Map visual / The Map visual
- Filled Map visual / The Filled Map visual
- Shape Map visual / The Shape Map visual
- ArcGIS Map visual / The ArcGIS Map visual
- Geographic Information Systems (GIS) / ArcGIS Map visual for Power BI
H
- hindcasting / Forecast line
- hybrid transactional and analytical processing (HTAP) / Columnstore and HTAP
I
- Impact Bubble Chart / Impact Bubble Chart
- independent software vendors (ISVs) / Custom application embedding
- Infrastructure-as-a-Service (IaaS) / Import mode dataset queries, On-premises data gateway planning
- integrated development environment (IDE) / Development and management tools
- Integrated Scripting Environment (ISE) / PowerShell sample scripts
- interactive filtering / Interactive filtering
K
- Kerberos
- DirectQuery sources, single sign-on / Single sign-on to DirectQuery sources via Kerberos
- Kerberos Constrained Delegation (KCD) / Data source authentication
- Key Performance Indicator (KPI) / KPI Targets, Power KPI visual, Dashboards versus reports
- KPI data
- visualizing / Visualizing KPI data
- Gauge visual / The Gauge visual
- KPI visual / The KPI visual
L
- Line charts / Line and Area charts
- Live connection
- to Power BI datasets / Live connections to Power BI datasets
- reports, customizing / Customizing Live connection reports
- Live Connection
- about / Live Connection
- limitations / Limitations
- live report pages / Live report pages
- Load Balancer / Scale Power BI Report Server
M
- many-to-many relationships
- about / Many-to-many relationships
- cross-filtering direction / Cross-filtering direction
- filtering, enabling / Enabling filtering from the many side of a relationship
- Map visual / The Map visual
- map visuals
- about / Map visuals
- bubble map / Bubble map
- filled map / Filled map
- Master Data Management (MDM) / Identifying the dimensions
- Matrix visual / The Matrix visual
- measure evaluation process
- Initial Filter Context / Measure evaluation process
- about / Measure evaluation process
- Filter Context Modified via DAX / Measure evaluation process
- Relationship Cross-Filtering / Measure evaluation process
- Measure Logic Computation / Measure evaluation process
- measure support expressions
- about / Measure support expressions
- KPI targets / KPI Targets
- prior period / Current and prior periods
- current period / Current and prior periods
- M editing tools
- about / M editing tools
- advanced editor / Advanced Editor
- Visual Studio Code / Visual Studio Code
- Visual Studio / Visual Studio
- Merging Queries / Merging Queries
- metadata management
- about / Metadata management
- field descriptions / Field descriptions
- descriptions, creating / Creating descriptions
- view field descriptions / View field descriptions
- metadata, reporting / Metadata reporting
- query field descriptions / Query field descriptions
- standard metadata reports / Standard metadata reports
- server parameters / Server and database parameters
- DMVs, querying from Power BI / Querying the DMVs from Power BI
- DMV data, integrating / Integrating and enhancing DMV data
- DMV data, enhancing / Integrating and enhancing DMV data
- report pages / Metadata report pages
- M formula language
- about / M formula language
- #shared / #shared
- Microsoft Flow integration / Microsoft Flow integration
- Microsoft Office Data Connection (ODC) / Analyze in Excel
- mobile-optimized dashboards / Mobile-optimized dashboards
- mobile-optimized reports
- about / Mobile-optimized reports
- responsive visuals / Responsive visuals
- model metadata
- about / Model metadata
- visibility / Visibility
- column metadata / Column metadata
- field descriptions / Field descriptions
- month-to-date (MTD) / Date intelligence metrics
- M queries
- versus SQL views / SQL views versus M queries
- about / M queries
- Data Source Parameters / Data Source Parameters
- staging queries / Staging Queries
- DirectQuery staging / DirectQuery staging
- fact queries / Fact and dimension queries
- dimension queries / Fact and dimension queries
- Source Reference Only / Source Reference Only
- summary / M query summary
- excel workbook / Excel workbook – Annual Sales Plan
- data types / Data types
- item, accessing / Item access in M
- DirectQuery report execution / DirectQuery report execution
- Bridge Table Queries / Bridge Tables Queries
- parameter tables / Parameter Tables
- security tables / Security Tables
- examples / M Query examples
- three years filter, trailing / Trailing three years filter
- customer history column / Customer history column
- derived column data types / Derived column data types
- product dimension integration / Product dimension integration
- multi-dashboard architectures
- about / Multi-dashboard architectures
- single-dashboard architecture / Single-dashboard architecture
- multiple-dashboard architecture / Multiple-dashboard architecture
- organizational dashboard architecture / Organizational dashboard architecture
- multiple datasets / Multiple datasets
- multi-factor authentication (MFA) / Azure Active Directory, Conditional access policies
- Multidimensional Expressions (MDX) / Analysis Services
N
- navigation functions / Navigation functions – RELATED
O
- OAuth authentication, configuring
- Object Linking and Embedding, Database (OLE DB) / Data sources
- Office Online Server (OOS) / Office Online Server for Excel Workbooks
- On-premises data gateway
- planning / On-premises data gateway planning
- planning tasks / Top gateway planning tasks
- usage, determining / Determining whether a gateway is needed
- installation, identifying / Identifying where the gateway should be installed
- infrastructure, defining / Defining the gateway infrastructure and hardware requirements
- hardware requisites, defining / Defining the gateway infrastructure and hardware requirements
- versus personal mode / On-premises data gateway versus personal mode
- configuration / Gateway configuration
- service account / The gateway service account
- TCP, versus HTTPS mode / TCP versus HTTPS mode
- troubleshooting / Troubleshooting and monitoring gateways
- monitoring / Troubleshooting and monitoring gateways
- restore, selecting / Restoring, migrating, and taking over a gateway
- migrate, selecting / Restoring, migrating, and taking over a gateway
- take over / Restoring, migrating, and taking over a gateway
- log files / Gateway log files
- performance-monitor counters / Performance Monitor counters
- Online Analytical Processing (OLAP) / Analysis Services
- Open Database Connectivity (ODBC) / Data sources, On-premises data gateway planning
P
- parameter tables
- about / Parameter Tables, Parameter tables
- measure groups / Measure groups
- last refreshed date / Last refreshed date
- measure support logic / Measure support logic
- partial query folding / Partial query folding
- performance optimization
- about / Optimizing performance
- import / Import
- columnar compression / Columnar compression
- memory analysis via DMVs / Memory analysis via DMVs
- DirectQuery / DirectQuery
- performance testing
- about / Performance testing
- DAX Studio / DAX Studio
- personal mode
- versus on-premises data gateway / On-premises data gateway versus personal mode
- Platform-as-a-Service (PaaS) / On-premises data gateway planning, Feature differences with the Power BI service
- Power BI admin portal
- about / Power BI Admin Portal
- usage metrics / Usage metrics
- Users and Audit logs / Users and Audit logs
- Tenant settings / Tenant settings
- Embed Codes / Embed Codes
- Organizational Custom visuals / Organizational Custom visuals
- Power BI apps
- about / Power BI apps
- licensing apps / Licensing apps
- app deployment process / App deployment process
- user permissions / User permissions
- publishing / Publishing apps
- installing / Installing apps
- mobile apps / Apps on Power BI mobile
- updates / App updates
- dataset-to-workspace relationship / Dataset-to-workspace relationship
- versus sharing dashboards and reports / Sharing versus Power BI apps
- Power BI custom visuals
- leveraging / Leveraging Power BI custom visuals
- Power BI datasets
- Live connections / Live connections to Power BI datasets
- source datasets, switching / Switching source datasets
- Power BI deployment, modes
- about / Power BI deployment modes
- Corporate BI / Corporate BI
- Self-Service Visualization / Self-Service Visualization
- Self-Service BI / Self-Service BI
- selecting / Choosing a deployment mode
- Power BI Desktop
- reference / Getting started
- features / Getting started
- versus Analysis Services / Analysis Services Models versus Power BI Desktop
- migrating, to Analysis Services / Migration of Power BI Desktop to Analysis Services
- Power BI licenses
- about / Power BI licenses
- scenarios / Power BI license scenarios
- Power BI Premium features / Power BI Premium features
- Power BI mobile applications / Power BI mobile applications
- Power BI Premium
- about / Power BI Premium
- capabilities / Power BI Premium capabilities
- Corporate Power BI datasets / Corporate Power BI datasets
- capacity nodes / Premium capacity nodes
- frontend resource, versus backend resource / Frontend versus backend resources
- Power BI Premium administrators
- responsibilities / Power BI Premium capacities
- Power BI Premium calculator
- Power BI Premium capacities
- about / Power BI Premium capacities
- allocation / Capacity allocation
- monitoring / Create, size, and monitor capacities, Monitor premium capacities
- creating / Create, size, and monitor capacities
- sizing / Create, size, and monitor capacities
- size, modifying / Change capacity size
- app workspace assignment / App workspace assignment
- capacity admins / Capacity admins
- Power BI Premium capacity allocation
- about / Power BI Premium capacity allocation
- Corporate BI Capacity / Corporate and Self-Service BI capacity
- Self-Service BI capacity / Corporate and Self-Service BI capacity
- resource utilization / Power BI Premium resource utilization
- data model optimizations / Data model optimizations
- report optimization / Report and visualization optimizations
- visual optimization / Report and visualization optimizations
- Power BI Premium P2 / Hardware and user licensing
- Power BI project roles
- about / Power BI project roles
- dataset designer / Dataset designer
- report authors / Report authors
- Power BI admin / Power BI admin
- project role collaboration / Project role collaboration
- Power BI project template
- about / Sample Power BI project template
- Adventure Works BI / Sample template – Adventure Works BI
- Power BI publisher for Excel
- about / Power BI Publisher for Excel
- URL / Power BI Publisher for Excel
- Power BI Report Server (PBIRS)
- about / SQL Server Reporting Services
- planning / Planning for the Power BI Report Server
- feature differences / Feature differences with the Power BI service
- SQL Server Reporting Services / Parity with SQL Server Reporting Services
- data sources / Data sources and connectivity options
- connectivity options / Data sources and connectivity options
- hardware, requisites / Hardware and user licensing
- user licensing / Hardware and user licensing
- pro licenses, for report authors / Pro licenses for report authors
- alternative deployment models / Alternative and hybrid deployment models
- hybrid deployment models / Alternative and hybrid deployment models
- reference topology / Report Server reference topology
- URL / Installation
- Power BI service
- deploying / Deploying to the Power BI service
- DATASETS / DATASETS
- WORKBOOKS / WORKBOOKS
- data refreshes, scheduling / Scheduling data refreshes
- Power BI service administrator role / Power BI admin
- Power BI Template (.PBIT) / Data Source Parameters
- Power Query Editor / The Power Query Editor
- premium capacity estimations / Premium capacity estimations
- privacy levels
- about / Privacy levels
- public / Privacy levels
- organizational / Privacy levels
- private / Privacy levels
- none / Privacy levels
- Profit Margin, calculated measure
- optional parameters / Optional parameters
- project analysis / Sample project analysis
- proof-of-concept (POC) / Choosing a deployment mode
- Provision Azure Analysis Services / Provision Azure Analysis Services
- Publish to web / Publish to web
- Pulse chart / Pulse Chart
Q
- query design per dataset mode
- about / Query design per dataset mode
- import mode dataset queries / Import mode dataset queries
- DirectQuery dataset queries / DirectQuery dataset queries
- query folding
- about / Query folding
- partial query folding / Partial query folding
- Query Processing Units (QPUs) / Provision Azure Analysis Services
- Quick Insights
- about / Quick Insights
- features / Explain the increase/decrease
R
- R
- leveraging / Leveraging R
- installing / Installation and configuration
- configuring / Installation and configuration
- script transform / The R Script transform
- ranking metrics
- about / Ranking metrics
- dynamic ranking measures / Dynamic ranking measures
- relationships
- building / Building relationships
- editing / Editing relationships
- creating / Creating a new relationship
- about / Relationships
- uniqueness / Uniqueness
- ambiguity / Ambiguity
- Remove Columns / Remove Columns
- report design summary / Report design summary
- report filter scopes
- about / Report filter scopes
- conditions / Report filter conditions
- report filters / Report and page filters
- page filter / Report and page filters, Page filter or slicer?
- slicer / Page filter or slicer?
- relative date filtering / Relative date filtering
- report planning
- about / Report planning
- Power BI report architecture / Power BI report architecture
- reports
- versus dashboards / Dashboards versus reports
- sharing / Sharing dashboards and reports
- Report server administration
- about / Report server administration
- Power BI report content, securing / Securing Power BI report content
- execution logs / Execution logs
- Report Server Configuration Manager
- about / Configuration
- Service Account / Service Account
- Remote Report Server Database / Remote Report Server Database
- Office Online Server, for Excel Workbooks / Office Online Server for Excel Workbooks
- Report Server Desktop Application
- about / Report Server Desktop Application
- desktop versions, executing side-by-side / Running desktop versions side by side
- Report Server product key
- retrieving / Retrieve the Report Server product key
- Report Server Web Portal
- about / Report Server Web Portal
- scheduled data refresh / Scheduled data refresh
- data source authentication / Data source authentication
- responsive visuals / Responsive visuals
- return on investment (ROI) / Sample Power BI project template
- Ribbon Chart / The Ribbon Chart
- role-playing tables
- about / Role-playing tables
- date table, importing / Importing the date table
- row-level security
- setting up / Setting up row-level security
- row-level security (RLS) / Self-Service BI, Privacy levels, Security Tables, User permissions, Azure Active Directory
S
- scalar function / Scalar and table functions
- Scale Power BI Report Server / Scale Power BI Report Server
- Scatter chart / The Scatter chart
- scatter charts / Scatter charts
- scopes
- sharing / Sharing scopes
- security roles
- about / Security roles
- dynamic row-level security / Dynamic row-level security
- security tables / Security Tables
- Selection Pane / Selection pane and the Spotlight property
- self-service BI (SSBI) / Data governance for Power BI
- Self-Service BI Capacity / Corporate and Self-Service BI capacity
- Self-Service BI workspace
- about / Self-Service BI workspace
- content distribution / Self-Service content distribution
- risks / Risks to Self-Service BI
- Shape Map visual / The Shape Map visual
- SharePoint Online embedding / SharePoint Online embedding
- Show Value as / Show value as
- Single Dataset Across Workspaces / Power BI Premium capabilities
- single sign-on (SSO) / On-premises data gateway planning
- slicers
- about / Slicers
- synchronization / Slicer synchronization
- custom slicer parameters / Custom slicer parameters
- Slicer visual / The Slicer visual
- Software-as-a-Service (SaaS) / Feature differences with the Power BI service, Custom application embedding
- Spotlight property / Selection pane and the Spotlight property
- SQL Server
- using, for data import / SQL Server as a source
- SQL Server Analysis Services (SSAS) / Importing data
- about / Corporate BI, SQL views versus M queries, Live connections to Power BI datasets, On-premises data gateway planning, Office Online Server for Excel Workbooks, Data source authentication, Dataset-to-workspace relationship, Data governance for Power BI, Premium capacity estimations
- versus Analysis Services / Azure Analysis Services versus SSAS
- migrating, to Analysis Services / SSAS to Azure AS Migration
- SQL Server Data Tools (SSDT) / SQL Server Reporting Services, Feature differences with the Power BI service, Report Server Web Portal, Scale
- SQL Server Integration Service (SSIS) / Data profiling, Data governance for Power BI, Audit log monitoring solutions, Azure Analysis Services versus SSAS
- SQL Server Management Studio (SSMS) / DAX Studio, Tracing a Power BI dataset via DAX Studio, Live connections to Analysis Services models, Scheduled data refresh, Securing Power BI report content, Development and management tools
- SQL Server Reporting Services (SSRS)
- SQL view
- about / SQL views
- versus M queries / SQL views versus M queries
- examples / SQL view examples
- date dimension view / Date dimension view
- Mark As Date Table / Mark As Date Table
- Product Dimension view / Product Dimension view
- dimensions, modifying / Slowly-changing dimensions
- staged deployment
- about / Staged deployments
- workspace datasets / Workspace datasets
- workspace dataset / Workspace datasets
- Power BI REST API / Power BI REST API
- client application ID / Client application ID
- workspace / Workspace and content IDs
- content IDs / Workspace and content IDs
- PowerShell sample scripts / PowerShell sample scripts
- string functions / String functions – Month, Year
- subject matter experts (SMEs) / Project discovery and ingestion
- SWITCH function / SWITCH() – age breakdown
T
- table functions / Scalar and table functions
- tables
- versus charts / Tables versus charts
- table visual / The table visual
- tabular data
- visualizing / Visualizing tabular data
- table visual / The table visual
- Matrix visual / The Matrix visual
- Tabular Model Scripting Language (TMSL) / Development and management tools
- Team Foundation Server (TFS) / Visual Studio
- time intelligence, filter context
- Year to Date Sales / Year to Date Sales
- YTD Sales (Fiscal Calendar) / YTD Sales (Fiscal Calendar)
- Prior Year Sales / Prior Year Sales
- Top N filter / The Top N filter
- transform
- basics / Transform basics
- deleting transforms / Transform basics
- modifying transforms / Transform basics
- order of transforms, changing / Transform basics
- Use First Row as Headers / Use First Row as Headers
- Remove Columns / Remove Columns
- Change Type / Change type
- Add Column From Examples / Add Column From Examples
- Treemap visual / The Treemap visual
- trend data
- visualizing / Visualizing trend data
- Line charts / Line and Area charts
- Area charts / Line and Area charts
- Combo charts / Combo charts
- Ribbon Chart / The Ribbon Chart
- Waterfall Chart / The Waterfall Chart
- Funnel Chart / The Funnel Chart
- Trend Line / Trend Line
U
- Unpivot / Unpivot
- upgrade cycles / Upgrade cycles
- usability enhancements
- about / Usability enhancements
- tables, hiding / Hiding tables and columns
- columns, hiding / Hiding tables and columns
- tables, renaming / Renaming tables and columns
- columns, renaming / Renaming tables and columns
- default summarization / Default summarization
- column, displaying / How to display one column but sort by another
- column, sorting / How to display one column but sort by another
- data categorization / Data categorization
- hierarchies, creating / Creating hierarchies
- usage metrics reports / Usage metrics reports
- Use First Row as Headers / Use First Row as Headers
- user acceptance testing (UAT) / Staged deployments
- User Principal Name (UPN) / Dynamic row-level security, Email Subscriptions
V
- values
- pie charts / Pie and Donut charts
- version control
- about / Version control
- OneDrive, for Business version history / OneDrive for Business version history
- source control, for M code / Source control for M and DAX code
- source control, for DAX code / Source control for M and DAX code
- source code, for DAX code / Source control for M and DAX code
- view mode / View mode
- virtual machines (VMs) / On-premises data gateway planning, Azure Analysis Services versus SSAS
- visual
- selecting / Choosing the visual
- tables, versus charts / Tables versus charts
- chart selection / Chart selection
- visual interactions
- about / Visual interactions
- edit interactions / Edit interactions
- what-if parameters / What-if parameters
- visualization
- best practices / Visualization best practices
- anti-patterns / Visualization anti-patterns
- visualization, formatting
- about / Visualization formatting
- visual-level formatting / Visual-level formatting
- line and column / Line and column charts
- tooltips / Tooltips
- report page tooltips / Report page tooltips
- column-chart conditional formatting / Column chart conditional formatting
- line chart conditional formatting / Line chart conditional formatting
- table / Table and matrix
- matrix / Table and matrix
- table conditional formatting / Table and matrix conditional formatting
- matrix conditional formatting / Table and matrix conditional formatting
- values as rows / Values as rows
- scatter charts / Scatter charts
- visuals, filtering
- interactive filtering / Interactive filtering
- Slicer visual / The Slicer visual
- Visual Studio Team Services (VSTS) / Visual Studio, Version control, Analysis Services Models versus Power BI Desktop
- Volume Licensing Service Center (VLSC) / Retrieve the Report Server product key
W
- Waterfall Chart / The Waterfall Chart
- waterfall chart breakdown / Waterfall chart breakdown
- Web
- using, as source / Web as a source
- Web Data Connector (WDC) / Conventions used, Determining whether a gateway is needed
- week-to-date (WTD) / Date intelligence metrics
- WORKBOOKS / WORKBOOKS
- workspaces / Workspaces
Y
- year-over-year (YOY) / Current versus prior and growth rates, Report planning
- year-over-year year-to-date (YOY YTD) / Current versus prior and growth rates
- year-to-date (YTD) / Dataset designer, Pulse Chart