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,
I have applied RLS to an embedded report and it works as it should in some respects but not others.
Below is just a snippet of the model setup and where I am having the issue.
RLS is applied to the UserID/RetailerID table, [UserID]=Username(). This then filters the retailer ID's in the connected table based on what that User ID can see and in my actual model that then connects to the main data and filters that accordingly and works as it should.
When I use the 'View As' function in Desktop, this enacts the 2 way relationship between the retailer and retailer group tables meaning in a slicer with the retailer groups in it, the user can ONLY see the groups they are affiliated with via the retailer table. When I view this report once published and via the site it is embedded on, the RLS works and filters the data, but I can see ALL retailer groups in the retailer group slicer and it is not behaving as it does in the 'View As'.
Any ideas?
Thanks.
For anyone else who may need the answer to this question:
I had this problem on my data model, and I solved it by enabling the security filter to go both directions.
- from Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Bump
Hi @xuxxay88 ,
Are Retailer ID and Retailer Group ID the same?
Otherwise how do you connect these two tables?
Best Regards,
Jay
Hi,
Apologies in the Retailer table it holds the Retailer ID, Retailer Name and Retailer Group ID, the Group ID then connects to the Group Table.
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.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |