cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Nikill Frequent Visitor
Frequent Visitor

Power BI, RLS and bidirectionnal cross-filtering

Hello,

I'm having issue understanding bidirectionnal cross-filtering. Maybe I'm completely missing the point there but if I could have any explanation that could be great.

I have a RLS defined on one table in a very regular way, think groups like Manager/Accountant/Salesman on a typical employee table 

I want the data for the other tables to be filtered out depending on the user group (for instance if an Accountant is building reports on powerbi.com based on this dataset, I don't want him to be able to see the salary of Salesmen/Managers from the Salary table).

Is bidirectionnal cross-filtering the right answer to this case ? Shall I check this in the relation between my Employee table and my Salary table in the Model ?

Thanks a lot for your inputs,

Cheers,

Nicolas

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Power BI, RLS and bidirectionnal cross-filtering

Hi @Nikill,

 

>>That raise another question : does the RLS applies when an user (in a certain RLS group) is designing a report from Web Interface ? 

What 'web interface' you mean? Power bi embed or report create on power bi service side?

 

If you mean RLS with power bi embedded, current it support RLS but you can't edit online.

 

For report you create online, power bi service not support add or edit RLS, you can only edit on desktop side and assign roles on service side.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

5 REPLIES 5
Community Support Team
Community Support Team

Re: Power BI, RLS and bidirectionnal cross-filtering

HI @Nikill,

 

For your scenario, I' like to suggest you to setting RLS on group level. (use USERNAME function with relationship to found group role of current user, then apply filter effect on group level)

 

After these steps, your data will be filtered based on group and their relationships, these unmatched group roles will be hidden.

 

If you mean your data has multiple level and parent can view its childrens data, I think you need to add condition to check user level before apply group roles filters.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI
Nikill Frequent Visitor
Frequent Visitor

Re: Power BI, RLS and bidirectionnal cross-filtering

Hi @v-shex-msft,

Thanks a lot for your answer. 

Indeed I'll use RLS the way you mention it. But my point was more, in the case of an user accessing directly the dataset through the workspace on PowerBI.com and using the web browser to design a report, if this user pulls data from the salary table, he will be able to see all salaries listed until he adds a columns from the Employee table, where the filter will then be instantly applied. 

That raise another question : does the RLS applies when an user (in a certain RLS group) is designing a report from Web Interface ? 

thanks again for your answer,

Nicolas

Community Support Team
Community Support Team

Re: Power BI, RLS and bidirectionnal cross-filtering

Hi @Nikill,

 

>>That raise another question : does the RLS applies when an user (in a certain RLS group) is designing a report from Web Interface ? 

What 'web interface' you mean? Power bi embed or report create on power bi service side?

 

If you mean RLS with power bi embedded, current it support RLS but you can't edit online.

 

For report you create online, power bi service not support add or edit RLS, you can only edit on desktop side and assign roles on service side.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Nikill Frequent Visitor
Frequent Visitor

Re: Power BI, RLS and bidirectionnal cross-filtering

Hi @v-shex-msft

I think I am very close to my solution with your answer. 

Indeed, I am speaking of designing reports directly on powerbi.com from a dataset. What I want to know is if the RLS applies on the report the RLS affected user is designing in his browser. It's fine if he can't manage RLS through web as I ertainly don't want him to do that.

Thanks a lot,

Nicolas

Emmanuelojo Frequent Visitor
Frequent Visitor

Re: Power BI, RLS and bidirectionnal cross-filtering

I built a report, applying RLS. one thing have noticed was, on the dimention table where i applied the Security, the security works but the data dont Change as i was expect to filter based on the Security. whilst on the report the slicer work as it should. Please Help

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors