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

Reza Rad

Dec 2019 · RADACAD Systems Limited

Ebook

108

Pages

Eligible

Ratings and reviews aren’t verified Learn More

About this ebook

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.

About the author

Reza Rad is a Microsoft Regional Director[https://rd.microsoft.com/en-us/reza-rad], an Author, Trainer, Speaker, and Consultant. He has a BSc in Computer engineering; he has more than 20 years of experience in data analysis, BI, databases, programming, and development, mainly on Microsoft technologies. He is a Microsoft Data Platform MVP[https://mvp.microsoft.com/en-us/PublicProfile/4030647?fullName=Reza%20%20Rad] for 11 straight years (from 2011 till now) for his dedication to Microsoft BI. Reza is an active blogger and co-founder of RADACAD[https://radacad.com/]. Reza is also co-founder and co-organizer of the Difinity[http://difinity.co.nz/] conference in New Zealand, and the Power BI Summit[https://www.globalpowerbisummit.com/] (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 Data, Insights, and Power BI user group in Auckland, New Zealand (Since Microsoft Fast Track Recognized Solution Architect – Power Platform

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

Microsoft Certified professional

His articles on different aspects of technologies, mainly on BI, can be found on his blog: https://radacad.com/blog[https://radacad.com/blog].

He wrote some books on Microsoft BI and also is writing some others. He was also an active member on online technical forums such as MSDN and Experts-Exchange, was a moderator of MSDN SQL Server forums, and is an MCP, MCSE, and MCITP of BI. He is the leader of the Power BI and Analytics users group[https://www.meetup.com/New-Zealand-Business-Intelligence-User-Group/]. He is also the author of the very popular book Power BI from Rookie to Rock Star[https://radacad.com/online-book-power-bi-from-rookie-to-rockstar], which is free with more than 1700 pages of content and the Power BI Pro Architecture[https://www.apress.com/gp/book/9781484240144]. He also wrote a book on Row-Level Security in Power BI[https://www.amazon.com/gp/product/B082SFR2J4], Basics of Power BI modeling[https://www.amazon.com/gp/product/B08HWNZ7GC] and Power BI DAX Simplified[https://www.amazon.com/gp/product/B099SBN1XP], which are valuable assets for Power BI users.

He is an International Speaker in Microsoft Ignite, Microsoft Business Applications Summit, Data Insight Summit, PASS Summit, SQL Saturday, and user groups. And He is a Microsoft Certified Trainer.

LinkedIn: Reza Rad[https://www.linkedin.com/in/rezarad/]

Twitter: Reza Rad[https://twitter.com/Rad_Reza]

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.

Report illegal content