cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mapowe
Microsoft
Microsoft

Using UserObjectId for Row Level Security

Hi,

I'm trying to implement row-level security using the UserObjectId instead of UserPrincipleName

 

To check this, I created a measure WhoAmI = USEROBJECTID()

 

In PBI Desktop, this measure on a card returns my Security Identifier.


But when published to PBI Service, the same card returns "pbidotcominternal.analysis.windows.net" even though I'm logged in with the same login.

 

So 2 questions:

1) Is it possible to implement RLS with the UserObjectId?

2) Why is the USEROBJECTID() not returning my AAD Object ID (expected behavior based on the documentation)?

1 ACCEPTED SOLUTION
GilbertQ
Super User II
Super User II

Hi @mapowe 

 

As far as I am aware you CANNOT use USEROBJECTID() because it cannot get the correct SID when using the Power BI Service.

 

You should be able to use the USERPRINCIPALNAME() which will return the logged in user, which will allow you to then use Object Level Security.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

1 REPLY 1
GilbertQ
Super User II
Super User II

Hi @mapowe 

 

As far as I am aware you CANNOT use USEROBJECTID() because it cannot get the correct SID when using the Power BI Service.

 

You should be able to use the USERPRINCIPALNAME() which will return the logged in user, which will allow you to then use Object Level Security.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.