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
Power BI, import report and semantic model: show change connection pop-up
When you need to import an existing Power BI report and semantic model in Tenant B that's created in Tenant A, you need to jump through a number of hoops to fix the original connection. It's doable, ...Reitse42 minutes agoMost Valuable ProfessionalNew4Views0likes0CommentsEnable per-user security for shared gateway connections using service accounts
When a shared gateway connection uses a highly privileged service account, all source queries run with that account’s permissions. Users cannot see the stored credentials, but report developers who c...AshishChougala1 hour agoMicrosoft EmployeeNew6Views2likes0CommentsRequest to add a feature to extract gateway connection status and last time credentials used
Could you please add a feature in the admin UI on Microsoft Fabric/Power BI to extract the Gateway connections with details of the gateway connection status and last activity information along with t...Vinodkumar_Chak2 hours agoNew MemberNew21Views1like0CommentsPower BI - incorrect handling of empty string parameter in DAX query in paginated report
Blank string parameters in paginated reports are treated as empty strings in Power BI Report Builder but as null values in the Power BI Service, resulting in incorrect report output. -> Create a pag...roshinikumarkar5 hours agoMicrosoft EmployeeNew25Views5likes0CommentsAllow NotebookUtils getSecret() to authenticate with Workspace Identity
Current behavior In Microsoft Fabric, notebookutils.credentials.getSecret() authenticates against Azure Key Vault using the identity of the user who executes the notebook. This behavior appli...tmihara7 hours agoNew MemberNew20Views1like1Comment