Pass Login User to Database

saket_mca1 — Wed, 10 Mar 2021 06:04:33 GMT

Hi,

We have requirement to pass login user to database parameter.

How we can perform this in PowerBI.

Regards

Saket

Re: Pass Login User to Database

v-janeyg-msft — Fri, 12 Mar 2021 07:58:16 GMT

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.

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.

josef78 — Mon, 22 Mar 2021 17:23:01 GMT

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

pleblanc — Mon, 29 Mar 2021 19:30:23 GMT

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