Forum Discussion
Sharepoint embed, get username
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?
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
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
1 Reply
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
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