Forum Discussion
Is RLS what I need?
I'm planning to close down a load of SQL driven .asp pages and replace them with Power BI reports. Currently I make sure that a user gets a unique dataset with a SQL query such as SELECT * FROM Table...
Thanks for that.
I haven't come across role settings yet - where can I find out about that and where are they defined?
I haven't come across role settings yet - where can I find out about that and where are they defined?
d_gosbell
Super User
Super UserIf you click on the Modelling tab in Power BI there is a manage roles button which brings up the following dialog box
In the role above users in the role will only see the one "SecureCostCentre" where it is equal to 1111 and this filter will flow down to any related tables.
This filter can be any valid DAX expression. In your case you could use the USERNAME() function in your filter to make a single dynamic role if you have a table in your model with a list of usernames that is then also related to the other tables in your model. So if you had a 'Users' table with a [Login] column you could create a filter expression like the following on your Users table.
Users[Login] = USERNAME()
- Wow thats fantastic, thank you all so much.
I'm going to have fun with this now!!!!