Book Image

Microsoft Power BI Complete Reference

By : Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell
Book Image

Microsoft Power BI Complete Reference

By: Devin Knight, Brian Knight, Mitchell Pearson, Manuel Quintana, Brett Powell

Overview of this book

Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. In this Learning Path, you will learn to create powerful interactive reports by visualizing your data and learn visualization styles, tips and tricks to bring your data to life. You will be able to administer your organization's Power BI environment to create and share dashboards. You will also be able to streamline deployment by implementing security and regular data refreshes. Next, you will delve deeper into the nuances of Power BI and handling projects. You will get acquainted with planning a Power BI project, development, and distribution of content, and deployment. You will learn to connect and extract data from various sources to create robust datasets, reports, and dashboards. Additionally, you will learn how to format reports and apply custom visuals, animation and analytics to further refine your data. By the end of this Learning Path, you will learn to implement the various Power BI tools such as on-premises gateway together along with staging and securely distributing content via apps. This Learning Path includes content from the following Packt products: • Microsoft Power BI Quick Start Guide by Devin Knight et al. • Mastering Microsoft Power BI by Brett Powell
Table of Contents (25 chapters)
Title Page
About Packt
Contributors
Preface
Index

DirectQuery datasets


For datasets built with DirectQuery connections to on-premises sources, authorized users of the gateway source will receive the following message when publishing from Power BI Desktop: 

Gateway assigned to the DirectQuery dataset

It's essential that the data source settings (for example, server name, database name) configured for the gateway data source exactly match the entries used by the Power BI dataset (.PBIX). Once the DirectQuery dataset has been published to the Power BI service, new reports can be built on top of this dataset via the Power BI service data source described in the Live connections to Power BI datasets section of Chapter 11, Creating and Formatting Power BI Reports.

Single sign-on to DirectQuery sources via Kerberos

Many organizations have made significant investments in scalable on-premises data sources and have implemented user security rules/conditions in these sources. For these organizations, it's often preferable to use DirectQuery data connections...