Forum Discussion
RLS in Power BI Service
Hi
I am trying to use RLS to display data in a report based on username/user principal name. We get to PowerBI service and set the security and add users and test role, it works beautifully, but I am unsure what else is required for it work after testing the role. For example, I only want to view projects that I own which is linked to my user account/email address, but for some odd reason I still view every projects. Even though the report was published by someone else and that person owns the workspace and I am only a viewer in that workspace, I am still seeing all the projects instead of the ones I own.
Also we tested this in PBI Desktop before publishing and works there too.
Am I missing a step?
Thank you,
SJ
Hi SJ -
This sounds like a similar use case to what i am working on too. Just to get more details, what filter have you set on the role in Power BI desktop. The roles have to set up on the PBI desktop and cannot be setup on the service. If you want to check it against your username, try using the function Username() instead.
I think you are doing everything right, must be that the filter for he role is not working correctly. You also have to make sure there is a relationship in the data model between the report and the username, so when you filter on the username it will filter to the right dataset.
3 Replies
Hi SJ -
This sounds like a similar use case to what i am working on too. Just to get more details, what filter have you set on the role in Power BI desktop. The roles have to set up on the PBI desktop and cannot be setup on the service. If you want to check it against your username, try using the function Username() instead.
I think you are doing everything right, must be that the filter for he role is not working correctly. You also have to make sure there is a relationship in the data model between the report and the username, so when you filter on the username it will filter to the right dataset.