March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I have RLS set up and it does work , however when publishing to the service the data for the last adviser is saved and when another adviser goes in on the service they see that data before they see theirs
Is there away of filtering the data to the adviser who has signed on
Thank you
Solved! Go to Solution.
Hello Julian_H,
have you checked the role via the security settings, test as role? Do you have the same experience there?
Hello Julian_H,
have you checked the role via the security settings, test as role? Do you have the same experience there?
Hi
Yep I get the same result.
It doesnt filter down unless you select the advisers name from the slicer drop down
Hello,
is it possible for you to share the dataset?
kind regards
Hi
Sorry I cant as the data is confidential .
All works ok apart from the last person to use its data still being available to the new user
Julian
That is normally not possible! Atleast the person will not see any data if the data filtered for other user.
What steps you have followed , need to be checked once!
Proud to be a Super User!
Hi
I have set the Manage roles on the adviser table that filters all the other tables.
And then in the service given the one adviser access in security but they see someone elses first before they filter. I am going to take the slicers of the page and see if that works
Thank you
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
25 | |
21 | |
11 | |
10 | |
9 |
User | Count |
---|---|
48 | |
30 | |
18 | |
17 | |
15 |