Row-Level Security in Power BI: The complete guide of creating different views of the data for the same Power BI report

$29.95
by Reza Rad

Shop Now
I have been writing and presenting about Row-Level Security in Power BI for many years. Through the comments and feedback I got from my presentations and articles, I felt a need for a place to have everything gathered in one place. The lack of a book that explains everything about the current subject motivated me to end up gathering all my articles in this book. The result is what you are reading.Row-Level Security in Power BI is not about sharing your content. It is, on the other hand, about sharing the same content with a different audience in the way that they see different views of the data. They will have different access to the data. Some of them might see the entire data, and some others might see part of the data that they are authorized to see.Instead of creating multiple reports with the same format, fields, calculations, and visualizations, and only making them different in filtering, the correct way to do it is through row-level security. This will make sure you have the maximum consistency and minimum maintenance for your Power BI project.This is not a book about theories. This is a hands-on book. There are tons of demos and examples with the code samples that you can try. You will learn through this book, what is row-level security. You will learn different types of security and patterns in which you will see the most common challenges for implementing the security and the solution to save them.The book starts with the basics of row-level security, then you will learn about static vs. dynamic row-level security. You will learn patterns such as everyone see their own data, but the manager sees a different view or users and profiles for branch managers. Or the organizational hierarchy, or even the many-to-many relationship challenge of row-level security etc. through this book.This book is not about how to create a report, build a visualization, connect to a dataset, or set up a gateway. If you want to learn those, I do recommend reading my other book: Power BI online book, from Rookie to Rock Star. I have been writing and presenting aboutRow-Level Security in Power BI for many years. Through the comments andfeedback I got from my presentations and articles, I felt a need for a place tohave everything gathered in one place. The lack of a book that explainseverything about the current subject motivated me to end up gathering all myarticles in this book. The result is what you are reading. Row-Level Security in Power BI is not aboutsharing your content. It is, on the other hand, about sharing the same contentwith a different audience in the way that they see different views of the data.They will have different access to the data. Some of them might see the entiredata, and some others might see part of the data that they are authorized tosee. Instead of creating multiple reports with thesame format, fields, calculations, and visualizations, and only making themdifferent in filtering, the correct way to do it is through row-level security.This will make sure you have the maximum consistency and minimum maintenancefor your Power BI project. This is not a book about theories. This is ahands-on book. There are tons of demos and examples with the code samples thatyou can try. You will learn through this book, what is row-level security. Youwill learn different types of security and patterns in which you will see themost common challenges for implementing the security and the solution to savethem. The book starts with the basics of row-levelsecurity, then you will learn about static vs. dynamic row-level security. Youwill learn patterns such as everyone see their own data, but the manager sees adifferent view or users and profiles for branch managers. Or the organizationalhierarchy, or even the many-to-many relationship challenge of row-level securityetc. through this book. Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker, and Consultant. He has more than 20 yearsof experience in data analysis, BI, databases, programming, and development,mainly on Microsoft technologies. He is a MicrosoftData Platform MVP for 11 straight years (from 2011 till now).Reza is an active blogger and co-founder of RADACAD. Reza is also co-founder and co-organizer of the Difinity conference in New Zealand, and the PowerBI Summit (the biggest Power BI conference) CEO at RADACAD - Chairman and Director at Power BI Summit - Chairman and Director at Difinity conference (Since 2017) - Microsoft Regional Director (Since 2018) - Microsoft Data Platform MVP (Since 2011) - Leader of Power BI user group in Auckland, New Zealand - Power BI All-Star award winner - Microsoft Power Platform Fast Track Solution Architect - Power BI - Dynamic Communities Emerald award winner - Author of more than ten books on BI, analytics, and Power BI - Speaker at many conferences such as Ignite, Microsoft Business Applications Summit, PASS, etc. - Blogger and content creator - Consultant and trainer - Microsoft Certified trainer - Mic

Customer Reviews

No ratings. Be the first to rate

 customer ratings


How are ratings calculated?
To calculate the overall star rating and percentage breakdown by star, we don’t use a simple average. Instead, our system considers things like how recent a review is and if the reviewer bought the item on Amazon. It also analyzes reviews to verify trustworthiness.

Review This Product

Share your thoughts with other customers