Page level filer by logged in username

[bruchiel]

I have a report that get data from iGlobe CRM a SharePoint Online App. I have created several reports succesfully. The attached shows all companies. Now I want to create a page with a page level filter where Accountmanager = the logged in user.

The goal is to have one page that will display data based on the logged in user showing only what is relevalt for that user. fx only to show the companies where the loggin user is accaount manager

[Drors]

Hi, try to follow this article 

http://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi

Basicly you need to make a table with all the usernames and then to use the function USERPRINCIPALNAME() in the RLS section.

[MFelix]

Hi  @bruchiel,

You need to use the Row level security (RSL) in power bi please check this link.

Regards,

MFelix

[bruchiel]

I have seen this in other post. But, I was hoping for an easier way. I mean we know the logged in user. It should be possible to use a filed with the username to set up a filter on page level. I do hope Microsoft would consider adding such a feature to Power BI.

Unless some one out there has a good idea?