Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
98 | |
69 | |
46 | |
39 | |
33 |
User | Count |
---|---|
157 | |
101 | |
60 | |
43 | |
40 |