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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
saket_mca1
Frequent Visitor

Pass Login User to Database

Hi,

We have requirement to pass login user to database parameter.  

How we can perform this in PowerBI.

 

Regards

Saket 

3 REPLIES 3
pleblanc
Microsoft Employee
Microsoft Employee

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

josef78
Memorable Member
Memorable Member

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

v-janeyg-msft
Community Support
Community Support

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.

v-janeyg-msft_0-1615535706402.png

 

  • 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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.