Hi @Imex197 ，
Depending on your needs.i think you can setting up row-level security (RLS) with Power BI Report Server，it can restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles thus achieving a similar purpose.
It is not possible to configure the information in SSMS to enable the specified user to access the corresponding custome visual.
Check the following document.
Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Docs
If the problem is still not resolved, please point it out and let me know immediately. Looking forward to your reply.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.