Contents

Introduction

Downloads

Installing the companion content

Acknowledgments

Free ebooks from Microsoft Press

Errata, updates, & book support

We want to hear from you

Stay in touch

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

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

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

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

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

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

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

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

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset