Book Image

Mastering Microsoft Power BI

By : Brett Powell
5 (1)
Book Image

Mastering Microsoft Power BI

5 (1)
By: Brett Powell

Overview of this book

This book is intended for business intelligence professionals responsible for the design and development of Power BI content as well as managers, architects and administrators who oversee Power BI projects and deployments. The chapters flow from the planning of a Power BI project through the development and distribution of content to the administration of Power BI for an organization. BI developers will learn how to create sustainable and impactful Power BI datasets, reports, and dashboards. This includes connecting to data sources, shaping and enhancing source data, and developing an analytical data model. Additionally, top report and dashboard design practices are described using features such as Bookmarks and the Power KPI visual. BI managers will learn how Power BI’s tools work together such as with the On-premises data gateway and how content can be staged and securely distributed via Apps. Additionally, both the Power BI Report Server and Power BI Premium are reviewed. By the end of this book, you will be confident in creating effective charts, tables, reports or dashboards for any kind of data using the tools and techniques in Microsoft Power BI.
Table of Contents (15 chapters)

Live connections to Analysis Services models

For on-premises SSAS models that Power BI users will access via Live connections, an SSAS data source must be added in the Manage gateways portal. Critically, the credentials entered for this data source in the Manage gateways portal must match an account that has server administrator permissions for the SSAS instance. The following image, from SQL Server Management Studio (SSMS), exposes the server administrator accounts for the ATLAS instance of SSAS Tabular:

Analysis Services Server administrators

Both SSAS and Azure Analysis Services instances can be accessed via SSMS. Additionally, the Analysis Server Properties dialog from the preceding image can be accessed by right-clicking the instance name. Identification of the Power BI user by SSAS will only work if a server admin account is specified and thus used when opening connections...