Forum Discussion
Hide reports or pages to users
Apologies that was bit of a rubbish explanation
When you deploy/save a PBIX form PBI Desktop you get to browse the folders on your PBI-ReportServer.
You can create folders on your PBI-ReportServer using the web front end. Usually http:\\yourservername\Reports\
You could create a folder called MyReportSubjectArea and then inside that folder create another folder called MyReportSubjectAreaSuperUsers. You can set security at folder level so restrict the MyReportSubjectArea folder to your main users and MyReportSubjectAreaSuperUsers to the more restricted set o users (we use AD groups to do this as it's way easier to add people to AD groups than adding and removing individual users via the SSRS web front end. (SSRS is the underlying server tech for PBI-ReportServer)
If you don't have any permissions on a folder you don't see it and can't access the contents even if someone sends you a link.
This page is about configuring SSRS security
Create a new role (site settings security). Add your sysadmin to this role. Now "manage" the "private folder" you created and customise its security so only the new role has access.
Your sysadmin shoudl be able to see the folder, your other login shouldn't. Add your other login to the role and the folder shoudl appear for them. Remove them and it shoudl vanish. Sometimes you have to kill the browser to get the fresh permissions as some of this stuff gets cached.
regards
S
Thank you Anonymous
Well it doesn't work or I didn't understand your hint.
I can create a new system role, but it depends on what activities I allow it on Reporting Services. Then, where should I add my sysadmin to this role? In Site settings on Report Server on in SQL? I don't know if you mean my super user on Power BI Report Server or SQL sysadmin. I don't even know how to manage the private folder so that only new role has access, as well. I thought I need an item level role, or not?
Thank you once again.
Nick
Sorry that was obviously a poor explanation. I can't produce a more detailed guide with screen shots at the moment as I'm no longer working with PBI on premise at my new company and haven't got access to an instance here.
It's basically the same as SSSR server so these two links should point you in the right direction.
http://www.andrewmosey.com/hiding-ssrs-folders-from-users
https://www.youtube.com/watch?v=d2E6B3TTUYg
The video is an older version of SSRS so looks pretty different but the fucntionality/approach is the same.
This is all about the users on the PBI ReportServer. So you need to log on as that user on a client machine and browse to the PBI ReportServer as that user to see the effect. If you're an admin on the PBI Report Server you get to see pretty much everything all the time.
regards
Steve
We actually use AD groups for this. So we assign the AD group to the role in SSRS/PBI-SSRS and then assign users into the AD group. But for testing it using a specific user login will work. It just gets difficult to maintain with lots of user