Page-Level Security workaround in Power BI

If you want to control the access to the Power BI report pages (or tabs) in a way that some users see some pages, and some others see other pages, we need something called page-level security. However, Power BI, as of today, doesn’t support visual-level or page-level security. There is a workaround to do it. Read more about Page-Level Security workaround in Power BI[…]

Power BI User Access Levels: Build and Edit are different

Often I have seen Power BI users have access to the areas that they shouldn’t. In Power BI, you can share a report with a user just for view only, or give them access to view and built, or to Edit. These are all different levels of access. Build access is the one that is Read more about Power BI User Access Levels: Build and Edit are different[…]

Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings

With the DirectQuery to Power BI or Azure analysis services dataset, there are some limitations on the way that RLS (Row-level security) works. Considering that I have written a book and many blogs on this subject, It was fair to have a look at how this works. In this blog and video, you will learn Read more about Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings[…]

Dynamic Row-Level Security in Power BI with Exclude and Include Rules

In the previous article, I explained how to implement a dynamic row-level security pattern when you have a value that you want to exclude. However, what if you want to EXCLUDE at some scenarios and INCLUDE in some others? What if you want to have a role saying access to everything but New Zealand, and Read more about Dynamic Row-Level Security in Power BI with Exclude and Include Rules[…]

Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule

Sometimes when you apply the dynamic row-level security, you want to have the criteria as NOT EQUAL and NOT IN. This can be a bit tricky in the dynamic implementation of RLS, because the relationship behavior is normally the opposite. In this article I’ll explain how you can do that. Introduction I have written many Read more about Dynamic Row-Level Security in Power BI with NOT IN or NOT EQUAL Rule[…]

What Do You Need to Implement Dynamic Row-Level Security in Power BI?

I have written some articles on the RLS topic already. Through my consulting experience, however, I get the feeling that many people can’t easily move from static RLS to dynamic. If you know what are things you need to have the dynamic RLS implemented, it makes the whole process simple. So this is what I Read more about What Do You Need to Implement Dynamic Row-Level Security in Power BI?[…]

Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security

In my previous article/video, I explained how you can hide sensitive data from the user’s view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to Read more about Secure the Sensitive Data in Power BI; Data Masking better with Row-Level Security[…]

Show the information but not the details: Power BI Data Masking

I wrote several row-level security articles so far, and a book. I explained how to restrict access to the data using row-level security approaches. However, one of the questions I got recently is this: “I want users to see one another’s sales information, but not to see who others are! How can I do that Read more about Show the information but not the details: Power BI Data Masking[…]

Share Different Visual Pages with Different Security Groups in Power BI

I have written a dozen of blogs and a book about Power BI row-level security and the security on the dataset. However, I always get this question that: “What if I want some people to see only a few pages of my report, and some others to see other pages?” or “How can I put Read more about Share Different Visual Pages with Different Security Groups in Power BI[…]

Calculating Total, and Percentages in a Row-Level Security Power BI Model

I have written dozens of articles about row-level security so far and explained in all of them explained different methods in which you can reduce the amount of data rows that a user can see based on their roles. However, in my presentations, I still get this question that: What if I want to compare Read more about Calculating Total, and Percentages in a Row-Level Security Power BI Model[…]