Introducing Microsoft Power BI

Front Cover
Microsoft Press Store
Exclusive offer for Introducing Microsoft Power BI readers!
Introduction
	Downloads
	Acknowledgments
	Free ebooks from Microsoft Press
	Errata, updates, & book support
	We want to hear from you
	Stay in touch
Chapter 1: Introducing Power BI
	Getting started with Power BI
	Uploading data to Power BI
	Introducing natural-language queries
	Introducing Quick Insights
	Introduction to reports
	Introducing Visual Interactions
	Decorating the report
	Saving the report
	Pinning a report
	Refreshing the budget workbook
	Filtering a report
	Conclusions
Chapter 2: Sharing the dashboard
	Inviting a user to see a dashboard
		Inviting users outside your organization
	Creating a group workspace in Power BI
	Turning on sharing with Microsoft OneDrive for Business
	Viewing reports and dashboards on mobile devices
	Conclusions
Microsoft Press Newsletter
Chapter 3: Understanding data refresh
	Introducing data refresh
	Introducing the Power BI refresh architecture
	Introducing Power BI Desktop
	Publishing to Power BI
	Installing the Power BI Personal Gateway
	Configuring automatic refresh
	Conclusions
Chapter 4: Using Power BI Desktop
	Connecting to a database
	Loading from multiple sources
	Using Query Editor
	Hiding or removing tables
	Handling seasonality and sorting months
	Conclusions
Tell us what you think (survey)
Chapter 5: Getting data from services and content packs
	Consuming a service content pack
	Creating a custom dataset from a service
	Creating a content pack for your organization
	Consuming an organizational content pack
	Updating an organizational content pack
	Conclusions
Chapter 6: Building a data model
	Loading individual tables
	Implementing measures
	Creating calculated columns
	Improving the report by using measures
	Integrating budget information
	Reallocating the budget
	Conclusions
Chapter 7: Improving Power BI reports
	Choosing the right visualizations
		Choosing between standard visuals
	Using custom visualizations
		First steps with custom visualizations
		Improving reports by using custom visualizations
		Identifying conditions when custom visualizations are required
	Using DAX in data models
	Creating high-density reports
	Conclusions
Chapter 8: Using Microsoft Power BI in your company
	Getting data from existing systems
		Understanding differences between data refresh and live connections
		Using relational databases on-premises
		Using relational databases in the cloud
		Using live connections to Analysis Services
	Integrating Power BI with Office
		Publish Excel data models in Power BI
		Consume Power BI content from Excel
		Using Power BI Tiles from Office Store
	Managing security to access data
		Using row-level security
	Extending and customizing Power BI
		Creating custom visualizations for Power BI
		Introducing the Power BI REST API
		Pushing real-time data to Power BI dashboards
		Power BI embedded in applications
	Conclusions
About the authors
Free ebooks from Microsoft Press