cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Peppermallow Frequent Visitor
Frequent Visitor

Power BI and SSRS Reports - restricted visiblity of SSRS reports

Is it possible to have some SSRS reports on our On Prem PowerBI site, such that users who have access to see and run them, can - and those who don't - can't even see them.  Specifically we have budget centre reports with staffing details, that ONLY managers should be able to see.  Average Joe users should be able to see the PBIX and SSRS reports available to them, but they shouldn't even know that an "Annual Salary by Department report" exists - much less try to run it.  They can't run it anyway, due to AD security on our datawarehouse - but we don't want them even trying to run it.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Power BI and SSRS Reports - restricted visiblity of SSRS reports

Hi @Peppermallow,

 

To restrict specific user can't see the report "Annual Salary by Department report", you can go to Manage -> Security section of this report, click Custom Security if the security inherited from parent level, then delete the permission for that user. 

 

q3.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-qiuyu-msft
Moderator

Re: Power BI and SSRS Reports - restricted visiblity of SSRS reports

Hi @Peppermallow,

 

To restrict specific user can't see the report "Annual Salary by Department report", you can go to Manage -> Security section of this report, click Custom Security if the security inherited from parent level, then delete the permission for that user. 

 

q3.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.