Forum Discussion

TKenny90's avatar
TKenny90
Regular Visitor
3 years ago

PBIRS Built-In Fields for PBIX

We have PBIRS server setup and we are using rdl and pbix files on there. The Report Server is embeded into a web app which various users use. We need to be able to restrict what each user sees on the...
"Power BI Report Server"
PBIRS
Power BI Desktop
TKenny90's avatar
TKenny90
Regular Visitor
3 years ago

We set permissions in a web app as to which branches a user can see. The user has an ID in the web app which is then fed through to a paginated report via custom auth. We pick this up in the UserId field (normally where I'd see the Windows user) for paginated reports and use this to filter branches based in what they can see in the web app. I was hoping I would be able to pick this UserId in a PBI report as I can the paginated reports?

 

The paginated reports and PBI reports both have Windows credentials to return the data from the data sources, which is one account per customer for us. 

mpsrshl's avatar
mpsrshl
Advocate II
3 years ago

I hope this helps, you can create the following role inside the PBI file, considering you are using the window user.

 

[EmployeeID] =
MAXX(
FILTER (
all('Employee'),
'Employee'[Email] = USERPRINCIPALNAME ()
|| 'Employee'[LDAPAccountID]
= MID ( USERPRINCIPALNAME (), 1, FIND ( "@", USERPRINCIPALNAME (), 1 ) - 1 )
),
'Employee'[EmployeeID]
)