Forum Discussion

MiesGijs's avatar
MiesGijs
New Member
2 years ago
Solved

Same dashboard multiple partners with RLS?

Hey!

 

We're looking for a new dashboarding tool and are looking into PowerBI right now. Hoping someone could help me with the following question:

 

We're a company that has multiple partners and in BigQuery we have data from all of them together in BigQuery tables. We want to create a single dashboard but have rules, so they could only see data they are permitted to see (If partner = 'x' show rows where partner in table = 'x', if partner = 'y' show rows where partner in table = 'y' for example). In the documentation I can't seem to find if it's possible to show the same visuals, or that I still have to make multiple duplicate dashboards and it's just a filter I have to put on every dashboard. https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

 

Thanks in advance!

  • Hi MiesGijs 
    The whole idea of RLS is that you build a single dashboard/report with identical visualizations, and filters are applied automatically based on permission settings, eliminating the need for individual reports/visualizations.

    Please refer to the linked video i think this can help :

    https://www.youtube.com/watch?v=jphj40tBPD8

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

1 Reply

  • Hi MiesGijs 
    The whole idea of RLS is that you build a single dashboard/report with identical visualizations, and filters are applied automatically based on permission settings, eliminating the need for individual reports/visualizations.

    Please refer to the linked video i think this can help :

    https://www.youtube.com/watch?v=jphj40tBPD8

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly