Forum Discussion
Show Slicer Values based on the logged in user in Power BI
Supritha1594 you can use Row-Level Security (RLS). Create a table showcasing user names and their corresponding accessible cost centers.
Navigate to the "Modeling" tab in Power BI Desktop and access "Manage Roles."
Initiate a new role by clicking on "Create."
Within the "Table Permissions" section, designate the table housing cost centers.
Move to the "Filter" section, opt for "Only show the rows where," and select the column with user names and cost centers. Save the role by clicking "OK."
Once you have created the role, you can publish the report to Power BI Service. This YouTube video should be helpful for you.Let me know if this works for you. @ me in replies, or I'll lose your thread!!!
Note:If this post is helpful, please mark it as the solution to help others find it easily. Also, if my answers contribute to a solution, show your appreciation by giving it a thumbs up!
Skilled SharerSupritha1594 you can use Row-Level Security (RLS). Create a table showcasing user names and their corresponding accessible cost centers.
Navigate to the "Modeling" tab in Power BI Desktop and access "Manage Roles."
Initiate a new role by clicking on "Create."
Within the "Table Permissions" section, designate the table housing cost centers.
Move to the "Filter" section, opt for "Only show the rows where," and select the column with user names and cost centers. Save the role by clicking "OK."
Note:
Thanks alot DallasBaba for your response! It really worked well...I followed the youtube video and the steps that you have mentioned above.
