The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
We have requirement to pass login user to database parameter.
How we can perform this in PowerBI.
Regards
Saket
You should be able to use the UserID function which returns domain\username.
Do you want in paginated report or direct query PBI report? Or you want impersonate user?
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.
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.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
7 | |
4 | |
4 | |
3 | |
2 |