Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Anonymous
Not applicable

Display/hide report URL:s on presentation page based on access

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: 

 

Skärmklipp1.PNG

2 REPLIES 2
dax
Community Support
Community Support

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.

477.PNG

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.

 

Anonymous
Not applicable

Hi, thanks for the reply!

Could this be used as a url to a different report, e.g. the "secret" sub reports?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.