Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi!
I have a presentation page which directs to separate sub reports like HR, Finance etc.
I want users who belong to, say a certain AD Group or similar, to be able to drilldown through an overview report (like HR, Financial) to their respective sub-reports. BUT, I only want the option (button) to appear if said user has extended access, and if they don't they can only see the overview reports and be unaware of sub report options.
Is this technically possible in Power BI?
Example:
Hi KDahlquist,
I am noy sure which visual you used to create button. If you use card, you could set it like below, you need to have a permission table in powerbi(you could set hide for that table), then you could use measure like below in Card
Measure 2 = if(USERPRINCIPALNAME() in ALLSELECTED('Table (2)'[name]),"you could view this", "")
Then people in permission table could view it.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thanks for the reply!
Could this be used as a url to a different report, e.g. the "secret" sub reports?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
79 | |
63 | |
61 | |
59 |
User | Count |
---|---|
166 | |
114 | |
100 | |
73 | |
67 |