Sharepoint embed, get username

[BiJoe]

Assume Azure AD (AAD) tenant, with Premium Power BI capacity, and a Sharepoint intranet page.

Our task is to present a simple Power BI dashboard in a Sharepoint page, with numbers filtered by the region the Sharepoint user belongs to. Reading the report in Power BI service is not an option in this case. 

Is it possible to extract the AAD user principal name, e.g. with DAX, and pass as a parameter to the PBI embedded report?

[v-yueyunzh-msft · Accepted solution]

Hi , @BiJoe 

For your question , for getting AAD, we can use the USERPRINCIPALNAME() DAX function, and you can refer to the following document for passing parameters:

https://stackoverflow.com/questions/54286048/how-to-pass-parameter-to-powerbi-embedded-report 

Using row-level security with embedded content in Power BI embedded analytics - Power BI | Microsoft...

USERPRINCIPALNAME function (DAX) - DAX | Microsoft Learn

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly