Book Image

Microsoft Power BI Cookbook

By : Author Test, Brett Powell
Book Image

Microsoft Power BI Cookbook

By: Author Test, Brett Powell

Overview of this book

Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI’s functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Power BI via detailed recipes, advanced design and development tips, and guidance on enhancing existing Power BI projects.
Table of Contents (14 chapters)

Introduction

Data security in which certain users or groups of users are prevented from viewing a portion of a dataset is often a top requirement in Power BI deployments. Security implementations can range in complexity from mapping user or security group accounts to simple security roles based on a single dimension value, to dynamic, user-based security with dedicated user permissions tables and dynamic DAX functions embedded in the dataset. Given the variety of use cases and the importance of this feature to securely share a dataset across stakeholders, it’s important to understand the process and techniques available for developing, testing, and operationalizing data security roles.

In addition to row level security (RLS) roles, dynamic user-based filter context techniques can also be used to simplify and personalize the user experience. For example, the filter conditions...