Dynamic Power BI report based on login user with no RLS

[xileize100]

Hi there,

I have been trying to set filters on report based on login user. This report references other's semantic model which I don't have any permision except view/read. I am not allowed to set row-level security on that dataset.

I tried to use a meaure like = USERNAME(), that measure can't be used in calculated column or table. 

here is the data table. What I am trying to do is: I need a column or measure to filter the data. for example: if a user XLY logins and opens the PBI report, he can only see records of employees Jack, Loam and Kison. If another user Zoi logins, he can only see the records of employees nirson, so on... I did lots of searching and testing, I still didn't have good luck. Can anyone help?

Thanks, 

Getha

Project	Balance	employee
101	2500	Jack
102	656	Loam
1003	100	Kison
1004	20	nirson
1005	13.38	nirson
1006	34.82	Den
1007	9.5	Jack
10020	90	Jack
11001	40.84	Asa

[Anonymous]

Hi @xileize100 

To set up dynamic RLS, you need to associate the user table with the data table. This user table needs to contain all users, as well as a field that contains their Power BI report login id . 

Dynamic Row Level Security Made Easy for Beginners (powerbiconsulting.com)

Second, RLS is built on a data model. You have to have edit access to the data model to be able to do that, and you currently only have read access to the report, you are not in a position to create an RLS.

Best Regards,
Community Support Team _ Ailsa Tao

[xileize100]

Thank you for your answers, Ailsa.

Yes. I can't use the built-in RLS feature due to the limited permission. I am trying to ask if there is any alternative way to get a dynamic report based on the login user. This seems a common question online asked by lots of people. I haven't found a solution for this. 

Thank you again, 

Getha.