Best way to have a site that lets someone see only their powerbi report

[charleshale]

Hi.  I am an experienced powerbi user who has not used the other Power Platform tools,  and who has a sharepoint instance that is a source of endless frustration. 

I am wondering if Power apps would be best for the following use case, or whether it's better to use Wix or the like.    Use case:

- I have a google survey connected to powerbi that takes a user down a diagnostic and reports back insights about their leadership and management in a score card such as the one below.  It's an amazing tool to help our managers become better leaders. 

- I am looking to put this system into an intranet site.   

- Main desired functionality is for a user to see their results and no one else's

Any comments, thoughts, suggestions?  

Thank you!

[christinepayton]

If the purpose is for people to be able to view their own rows or the rows of their direct reports, and you already have a Power BI report, I would just put row-level security on the Power BI report vs making an app. A Power App would be used if you wanted people to be in there editing the data. 

The DAX you want for the row-level security is USERPRINCIPALNAME() filtering on whatever your username field is in your data set for users-see-their-own-items. If you want to use your org hierarchy instead, you can use PATHCONTAINS() and PATH() on the reports-to field (I have a video link for how this works, if you want a link let me know). 

You can embed the report in SharePoint with the Power BI embed web part, the row-level security will still apply. 

[Anonymous · Accepted solution]

Hi  @charleshale ,

According to your question, if you want to realize the purpose is to realize that each user can see his/her own data (similar to the data in the score card) in Power apps, you can consider the following scheme to get the information of the currently logged-in app user in Power apps and try to see if it is possible to filter the data to each user's own data in the app by using Power fx expressions. There are two ways to do this.

(1) User().FullName: Returns the Office 365 profile of the currently logged in user.

Use the built-in function of User() Power fx to get the information table of the currently logged-in user, and then extract the value of FullName.

(2) Office365Users.MyProfileV2().displayName    

Use the Office365Users connector to get the information table of the currently logged in user and then extract the value of the field DisplayName.

Best Regards,

Liu Yang

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