Microsoft Power BI cookbook: creating business intelligence solutions of analytical data models, reports, and dashboards

Cover
 Title Page
 Copyright
 Credits
 Foreword
 About the Author
 About the Reviewers
 www.PacktPub.com
 Customer Feedback
 Table of Contents
 Preface
 Chapter 1: Configuring Power BI Development Tools
 Introduction
 Configuring Power BI Desktop options and settings
 Getting ready
 How to do it...
 Installing and running Power BI Desktop
 Configuring Power BI Desktop options
 How it works...
 There's more...
 See also
 Power BI's advantages over Excel
 Power BI Security and Data Source Privacy
 Installing the On-Premises Data Gateway
 Getting ready
 Hardware and network configuration How to do it...Installation of on-premises gateway
 How it works...
 Gateway recovery key
 There's more...
 See also...
 Installing Power BI Publisher for Excel
 How to do it...
 Installation of Power BI Publisher for Excel
 There's more...
 Installing and Configuring DAX Studio
 How to do it...
 Installation of DAX Studio
 Configuration of DAX Studio
 How it works...
 There's more...
 Guy in a Cube video channel
 Chapter 2: Accessing and Retrieving Data
 Introduction
 Viewing and analyzing M functions
 Getting ready
 How to do it...
 Formula Bar
 Advanced Editor window
 How it works... Query foldingM query structure
 Lazy evaluation
 There's more...
 Partial query folding
 Limitations of query folding
 See also...
 M language references
 Establishing and managing connections to data sources
 Getting ready
 How to do it...
 Isolate data sources from individual queries
 Query groups
 Manage source credentials and privacy levels
 How it works...
 Data Source settings
 Data source privacy settings
 There's more...
 See also
 Building source queries for DirectQuery models
 Getting ready
 How to do it...
 Applying M transformations with DirectQuery models
 How it works... There's more...DirectQuery project candidates
 DirectQuery performance
 See also
 Importing data to Power BI Desktop models
 How to do it...
 Denormalize a dimension
 Provide automatic sorting
 How it works...
 There's more...
 One GB dataset limit and Power BI Premium
 See also
 Applying multiple filtering conditions
 Getting ready
 How to do it...
 Query filter example steps
 How it works...
 There's more...
 Filtering via the Query Editor interface
 See also
 Choosing columns and column names
 How to do it...
 Identify expensive columns
 Select columns
 Rename columns
 How it works... Column memory usageThere's more...
 Fact table column eliminations
 Column orders
 See also
 Transforming and cleansing source data
 Getting ready
 How to do it...
 Remove duplicates
 Update a column through a join
 There's more...
 See also
 Creating custom and conditional columns
 How to do it...
 Create a dynamic banding attribute
 Create a formatted name column
 Comparing the current and previous rows
 How it works...
 Conditional expression syntax
 Case sensitivity
 Conditional expression evaluation
 Query folding of custom columns
 There's more...
 Add column from example