Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
We embed powerbi reports into our web platform. However, we wish to restrict the report by filter depending on the person who logged in, who will represent a customer class - i.e. Apple, Pear etc... So if someone from Pear logs in, the report will filter for Organisation=Pear, if Apple then Organisation=Apple etc...
How do I set this up please for embedded report filters?
Thanks.
Hi @SachinC ,
Row-level security (RLS) with Power BI can be used to restrict data access for given users. And all RLS rules are applied to the embeded report.
5. After the user has signed in, the report opens, showing the data and allowing page navigation and filter setting. Only users who have view permission can see the report in Power BI. All row-level security (RLS) rules are also applied. Lastly, the user needs to be correctly licensed – either they need a Power BI Pro license, or the report must be in a workspace that is in a Power BI Premium capacity. The user needs to sign in each time they open a new browser window. However, once signed in, other reports load automatically.
Reference: How to embed Power BI reports into portals.
It is needed to define roles and rules in Power BI Desktop and manage security on your model in Power BI Service. Then, RLS will work.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
26 | |
20 | |
18 | |
14 | |
11 |
User | Count |
---|---|
32 | |
20 | |
19 | |
18 | |
13 |