Page-Level Filter based on logged user

[Anonymous]

Hi,

I'm trying to create report that contains 1. page with all data and 2. page with data filtered out just for currently logged user.

(Business case is to have overview of opened requests for each user. On the 1st page anyone can see all opened requests and on the 2nd page he would see only his own - just for user convenience).

I'm struggling with it, because I thought I could use USERNAME() somewhere in filters, but apparently it is not possible, as it is not possible to create calculated collumn based on username 😞

Also I cannot apply RLS on my case, because I still want the users to see all the other data.

Thank you in advance for any suggestions 🙂

Zuzana

[v-xjiin-msft · Accepted solution]

Hi @Anonymous,

Currently as I know, the security in Power BI is just on Row level which is Row Level Security (RLS). And there already exists an Idea for the Page Level Security. You can vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/16059178-page-tab-level-security

Thanks,
Xi Jin.

[Drewdel]

Well that kinda sucks (>ε<  )  My supervisor just asked me to try to find a way to implement this very thing for all of our future reports.  Now I guess I have to give him the bad news.  Hopefully this feature gets enough votes and recognised to be put in a future update, that'd be nice.

[Anonymous]

Hi,

FYI I was able to evade this problem by solution which is not really very nice, but it is functional. I divided this report into 2 separate files that are linked by hypertext link in note at each page.  RLS for first report (Overview Report) is based on something else (or it could be without RLS at all) and second report (My Tasks Report) is based on UserName(). User is still able to se everything on 1.st report and then by clicking on that hypertext link he gets into My Tasks Report, which is filtered just for him. Only thing that is kind of unpleasant right now is that by clicking on hyperlink, the target pops up in new window.. but this is general problem of all PBI links. I hope MS will add some kind of solution to roadmap soon.

Z.