Controlling Access to the Dashboard based on User AD & Location

[Rhys_Unite]

Hi There

This maybe beyond my Power BI license but is there a way i can publish a dashboard\report, and then filter the report based on the person using it?!

So, John in London opens the PowerBi report via the embedded link, but he sees LONDON data only.

Our set up will have potentially 100 people from 20 different sites opening ONE REPORT, but we want to restrict its content so they can only see the relevant information relating to their site.

Is this possible.....if so, can it be done using a Pro license?  Can this be controlled via Groups\AD permissions?

Thanks in advance!!!

[v-tangjie-msft · Accepted solution]

Hi @Rhys_Unite ,

Yes, you can achieve this by implementing Row-Level Security (RLS) in your Power BI report. RLS allows you to restrict data access for specific users based on their roles or attributes. This way, when a user opens the report, they will only see the data relevant to their site.

To implement RLS, you need to:

1. Create roles in Power BI Desktop and define DAX expressions to filter the data based on the user's attributes.
2. Publish the report to Power BI Service.
3. Assign users or Active Directory (AD) groups to the roles you created in Power BI Service.

Please note that both you and the users you share the report with need a Power BI Pro license to access the report with RLS applied.

For more information on implementing RLS in Power BI, you can refer:

Automatically apply filters to your report per user - Kasper On BI

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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

[Rhys_Unite]

This is awesome, thank you!!!

The BI license for all users maybe the sticking point, but this work on an embedded link created within BI?