Hi, There is a User who has two roles. The access to these roles are maintained in a table which has all the dimensions as columns. For example if a User is a Geography Head, Geo_Id column will have that particular geography's code against the user. In our scenario the user is both Geography Head and also Vertical Head, and Geography code and Vertical code are populated against the user in the table. When we do Row level security, the data is fetched as a combination of Geography and Vertical, but the user should be able to see the whole data related to the Geo or the whole data related to the vertical(based on the user's preference of looking at the report). If the user wants to view the data as only the Geography head or the vertical head how can we achieve this?
1 Comment
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Variable Library: Disable default value set.
The Default Value Set in the Variable Library poses a risk. The Default Value Set will silently apply values when no explicit value set has been selected for a Test or Prod workspace. There i...frithjof_v3 hours agoCommunity ChampionNew630Views17likes2CommentsScheduled Refresh for Fabric Mirroring
Current Challenge: Fabric Mirroring runs continuously, leading to unnecessary data replication and higher Snowflake costs. There is no built-in option to schedule mirroring based on specific times o...ram_eternal1895 hours agoRegular VisitorNeeds Votes472Views3likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen6 hours agoAdvocate INew262Views42likes1CommentWhy are Calculation Groups so hard to modify?
Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. ...AaronReasoner7 hours agoNew MemberNew6Views0likes0CommentsFeature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures
Problem Statement: In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to ...Murtaza_Ghafoor10 hours agoSuper UserNew16Views2likes0Comments