Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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?
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.