Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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?