Checking out the new Power BI RLS Editor

This is awesome {"loop"}!!

Hi there,
Do you have a hint how to overcome RLS topology restrictions of limited relationships?
Having a dim table (RLS applied on it) in the remote model that filters a fact table in the local model: RLS is applied as expected, except for totals are visible, because there are not filters applied there. I was thinking about rewriting the measures adding a constant filter from that table with CALCULATE, but probably there are better approaches :)

Any tips to embedding Power BI Report to SharePoint site with RLS?

Will this remove the old dax rls? I currently have one master role which feeds into an excel sheet. The sheet then lists the users and all their different access rights. This made it easier to maintain as have over 100 different views and only need to update an excel row and not create a new role

Patrick you have not yet helped me in one of the matrix issue. How should I control the total and subtotal values for a hierarchy? I have posted it in community but it seems no one is that smart enough to crack it down.

I would still prefer Dax version though.

great video, short and to the point

I need to use RLS, but I want to show max, min and median without RLS. Can I turn off RLS for some measures? Thank you

Thanks. Great video !

This is awesome! What if I wanna see the data of "United States" in International as well?

Hey guys! Love this...

Ive been trying to get round RLS in my organisation, but keep stumbling with my project. I wonder if you could help.

Scenario: im building a Performance Mi dashboard for my organisation, but our data policy doesn't allow us to store personalised information on powerBi and publish it to the Service. Therefore, I'm not allowed to store email address details in the dashboard.

The dashboard works off of a direct query to a SQL database to extract the performance data.

Are you aware of a way for a published PowerBi dashboard to identify the user, alter the Direct Query and only extract that individuals data from the SQL Database?

Love the content, you guys are Heros!

For larger groups where you won't have auto access to email (or email won't match user principal name) you can create a spreadsheet that contains what they are allowed to see. The country would be a single field and you'd have to list each country separated by something, I use semicolon ";". In power Query, split the country column into rows and create a many to many relationship from your excel table to your sales table. Then in the Dax, the security says you can only see rows of the new table based on user principal name. It is still manual compared to other the other solution, but you can keep it in a secure folder location and updating security is as easy as updating a line in excel. The draw back is the user has to wait until the next refresh cycle for the changes to take place.

I was trying yesterday with userprincipalname and now I got to know why it's not working really helpful video...

Why always changing to more simple stuff which make sense but with putting "old" users to possible misleading approach.
I would feel better with the option to DAX activated by default. Anyway it is still a good move for non DAX users.

I still can't see this in power bi desktop... How to enable it... Can anyone help me?

Great video.

Apologies for unrelated:

Video request for your users: Field Parameters.

Use case:
Set up a field parameter with multiple measures, with an additional field grouping measures together. Use this on a matrix visual with an associated filter with these fields to allow users to choose which columns to include; this allows a ton of measures to be available to the user, with the benefit of only having the ones they want (as well as better performance). In addition, you can use field parameters to allow the user to include/exclude different drill down options (with bookmarks allowing multiple field parameter groups to change the order of the drill downs).

My experience comes from business users wanting Excel like experience in the form of Matrixes. Utilizing field parameters in this way has been very beneficial to their experience.

I'm happy to expand on this comment, just let me know.

I wish MS would just let us bulk import RLS... who cares about a different GUI for entering the data, just let us import it as some sort of flatfile!

Wonderful option

@guyinacube after you publish to the service and you are in the security section for that dataset and you've already added the user to the RLS role, is there a reason you chose to switch to a different user to show they had the correct access instead of using the test role option that comes up when you click the three dots That appear when you hover over the role name i.e Domestic

I feel like this isn't that new? or are we strictly talking about the switching between dax editor

I have a need to make dynamic RLS based upon Azure AD group memberships. But to do that I need to have a dataflow that calls the AD Graph API, bringing the various groups im using and their associated members, and to do that I need to have an app registration between Power BI and Azure AD to use Graph API data as a data source. It turns something seemingly straight forward into something overly complicated. 😢

This is an awesome addition! I have been looking for a solution to this use case in conjunction with RLS for a long time. We have an application that generates a 1:M access for RLS and works great. However, there is a cost associated with the user licensing for the app. The executives responsible for the respective portfolios never use the app itself but rather the output and analytics from that app. In the past we needed to provision a license to the app in order to provide the required access. This solves that problem! To your point, there is probably a less static and more sustainable solution to, for lack of a better term, hard-code it in the service but this opens up a tremendous opportunity for me. Thank you! Made my day.

How would you go about testing Dynamic RLS for multiple reports that share a dataset? The PBI Service GUI no longer allows you to "Test as..." for each report that is connected to a data model now.

@guyinacube another awesome video! Is there a way to hide a column in a visual for certain users? I have tried tabular editor but having much difficulty!

Gui is for basic or for simple rules, MS PBI team, this feature is like more dev time and less impact for users.

Hi Patrick

Awesome. I use RLS so sales people only see their commission sales and not everyone else’s.

Great video Patrick !

@guyinacube I wonder if we can use report parameters as the value in the dax expression

What version is that? I just installed 2.115.663.0 and I'm not seeing the same menu items in Manage Roles.

@GuyInACube Do you have any idea how to merge a live connected Power BI report to a Power BI dataset into one pbix file in import mode?

You are the best❤❤❤

If i was another user (MrSmith) and connected to the report, would I see both International and Domestic? Is the default to block all others? AND - Thanks for sharing 💥💥💥💥