Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Hi @bruchiel,
You need to use the Row level security (RSL) in power bi please check this link.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI 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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |