更新时间：2021-07-08 10:28:24
coverpage
Title Page
Copyright
Microsoft Power BI Cookbook
Credits
Foreword
About the Author
About the Reviewers
www.PacktPub.com
Why subscribe?
Customer Feedback
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Downloading the color images of this book
Errata
Piracy
Questions
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
Hardware and network configuration
Installation of on-premises gateway
Gateway recovery key
See also...
Installing Power BI Publisher for Excel
Installation of Power BI Publisher for Excel
Installing and Configuring DAX Studio
Installation of DAX Studio
Configuration of DAX Studio
Guy in a Cube video channel
Accessing and Retrieving Data
Viewing and analyzing M functions
Formula Bar
Advanced Editor window
Query folding
M query structure
Lazy evaluation
Partial query folding
Limitations of query folding
M language references
Establishing and managing connections to data sources
Isolate data sources from individual queries
Query groups
Manage source credentials and privacy levels
Data Source settings
Data source privacy settings
Building source queries for DirectQuery models
Applying M transformations with DirectQuery models
DirectQuery project candidates
DirectQuery performance
Importing data to Power BI Desktop models
Denormalize a dimension
Provide automatic sorting
One GB dataset limit and Power BI Premium
Applying multiple filtering conditions
