Pass Login User to Database

Hi, saket_mca1 

Do you want to set permissions?

The portal, folders, and files are secured using SSRS roles. Here is a high-level summary of the roles and how it affects Power BI Reports.

• Browser – This is similar to a read only function or if you would deliver the report as a Power BI App in the service. This should be used by anyone who needs access to the report, but does not create content.
• Content Manager – This is for a content creator with admin privileges. This role can manage content and user access.
• Publisher – This is for content creators who do not need to manage users. Most content creators fall into this category.
•  
• Report Builder – does not apply to Power BI Reports, which use Power BI Desktop to develop reports.

Reference:Power BI Report Server Configuration and Security Implementation - BetterConcepts (bconcepts.pt)

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Do you want in paginated report or direct query PBI report? Or you want impersonate user?

You should be able to use the UserID function which returns domain\username.