Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
Is it possible to give different users different rights for filter and downdrill possibilities?
I know the security level on data, but that is not enough.
Example: we show revenue of supermarkets
- user A can see the total revenue in a country
- user B can see the total revenues of supermarkets (within a country)
- user C can see the revenues of supermarkets in a specific category
Hence, user A&B can not see revenue of supermarket X in category Y of country Z. User B only sees revenue of supermarket X and user A can only see the total revenue of country Z.
Go to Solution.
@Anonymous hello, it's possible, but for this you must create a strutucre to made it possible using RLS.
Company | user | Market
1 A A
1 B A
2 C B
1 D A
i recommed you to use dynamic RLS to do this, take a look is this blog probally it well help you!
let me know!
View solution in original post
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.