USERPRINCIPALNAME() with PBI Dataset as source

[Anonymous]

Using USERPRINCIPALNAME() to give users a personal view of a report.  Works great. 

Reorganised the report so that the source is now an online PBI dataset and now when in PBI desktop the function returns the long alphanumeric string id instead of user@xxx.com.  Still works fine in the Service but its annoying for development as I cannot test the report properley without publishing.

Anyone else come across this? Any workaround?

[swise001 · Accepted solution]

@Anonymous 

You can typically override the result returned by USERPRINCIPALNAME() in Power BI Desktop by selecting "Test As" from the Security section of Modelling tab - and entering any target email.

Since you are connecting to a shared dataset - these options are disabled.  Given this limitation - the only workaround may be reguarly publish the report to a test/dev PBI service environment online.  I don't believe you can override USERPRINCIPALNAME() in PBI desktop when connecting to a shared dataset.     

[Anonymous · Accepted solution]

Hi @Anonymous,

Perhaps you can add RLS role to your data model to enable the UPN instead guid id string of user names.

For detailed descriptions, you can take a look at the following blog that told about similar issues(if it helps for your scenario) :

Using Username() in DAX with Row-Level Security 
Regards,

Xiaoxin Sheng

[swise001 · Accepted solution]

@Anonymous 

You can typically override the result returned by USERPRINCIPALNAME() in Power BI Desktop by selecting "Test As" from the Security section of Modelling tab - and entering any target email.

Since you are connecting to a shared dataset - these options are disabled.  Given this limitation - the only workaround may be reguarly publish the report to a test/dev PBI service environment online.  I don't believe you can override USERPRINCIPALNAME() in PBI desktop when connecting to a shared dataset.