Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
Solved! Go to 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:
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.
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:
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.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.