Set Different Levels of Access on the Same Dataset in Power BI using Row Level Security

Рет қаралды 35,307

Күн бұрын

Learn how to set different levels of access to the users of the same report and same dataset in Power BI using Row Level Security. The dataset link is available in my blog post here:
radacad.com/row-level-securit...

Пікірлер: 39

@zeeshanmohiuddin4686 3 жыл бұрын

A simple explanation of a complicated topic!

@mohsenhs 3 жыл бұрын

Thanks Rezajan, this was very helpful, I have been confused about RLS and Report sharing, your video helped me to understand the order of steps better.

@itsdredremandre 5 жыл бұрын

Thanks for this. Very useful for my reports

@kaveharshadi9632 5 жыл бұрын

Thank you very much again. :)

@ArifulIslam-gs6uy 3 жыл бұрын

Fantastic Presentation

@rodrigoolvera8108 3 жыл бұрын

Great video thanks so much!

@ettimehra 2 жыл бұрын

very clearly explained :)

@kilamtimus 4 жыл бұрын

Thanks a lot for simple and clear explanation! just wondering if we have videos on manage permissions also below the security option

@RADACAD 4 жыл бұрын

hopefully at some point

@tomaskachadourian1431 4 жыл бұрын

Hello RadaCad, thanks for the video, but how can u make a role where u can view Australia and also US sales?

@nimanth2u 3 жыл бұрын

thanks a lot.

@ramprasathselvamani8652 4 жыл бұрын

Waiting for dynamic row level security video.

@rossbailey1959 4 жыл бұрын

Very interesting video, thank you for posting it. I have a related question - I have 2 groups of users in my organisation. Operational staff and commissioners. I want the operational staff to be able to export the underlying data but the commissioners only to be able to export the summarised data. What is the most efficient way of doing this from the point of view of managing groups, and only having one version of the report, data set and workspaces?

@RADACAD 4 жыл бұрын

unfortunately there is no settings in the Power BI website at the moment to do this configuration. if a user can export data, they can export both. You need to create two different datasets, with two different tables, summarized in one, and detailed in another one.

@nguyettran6118 2 жыл бұрын

Hi! I generate an excel file by using Analyze in excel tool and sent to end users, so this Row level security will apply for the excel file that I generated too?

@MrBabuji123 3 жыл бұрын

Thanks for this . I an m having a problem while applying RLS to power bi service. Agfter defining riles and mail assigned to it, if i logg in power bi service as a diffretn user i do not se rls being applied whereas when i test it as a role in power bi service . it works. Kindly suggest why it is not being applied when i log in as diffrent use?

@dpalominoar 4 жыл бұрын

Hi, thanks for this, In the case that the report its in my company's sharepoint what happens whit the roles?

@RADACAD 4 жыл бұрын

doesn't matter where the report is. user will see only the data that they are authorized to see. if the report is hosted in sharepoint, still users are connecting to it using their Power BI accounts

@scottwourms4770 4 жыл бұрын

When using RLS, if the user chooses to export the underlying data, is it true that RLS will prevent the export of data that they do not have access to? Are there any potential issues in this regard?

@RADACAD 4 жыл бұрын

Correct. The user can only export the data that he or she has access to see, nothing more

@amit260183 3 жыл бұрын

Hi I want to create a Role that do not allow users to delete data from the source. Please suggest how to do that. Thanks Amit Srivastava

@techtips2398 2 жыл бұрын

Is it possible to apply dynamic RLS based on multiple columns? How?

@RADACAD 2 жыл бұрын

can you be more specific on what do you want to do with multiple columns?

@madiakns 4 жыл бұрын

Hi Reza, How can I setup multiple Hierarchy RLS? Sales Rep

@fulybrt26 4 жыл бұрын

hi can i do this restriction also in pages instead of tables?

@ibtihelhacheni6284 4 жыл бұрын

hello, i have the same question, did you find a answer for your question ?

@2020emadina 5 жыл бұрын

Thanks Reza, I was wondering how to apply RLS for 300 sales people to only show each sales person his orders only. Thanks Emad

@RADACAD 5 жыл бұрын

for that you need to implement Dynamic RLS. I have written tons of articles about it at radacad.com. videos will come also

@AMITKUMAR-mt7xf 5 жыл бұрын

You can try Dynamic level Security, use USERPRINCIPLENAME() to take advantage of user logged in

@2020emadina 5 жыл бұрын

RADACAD thanks Reza

@Fernando_Calero 5 жыл бұрын

Hi Reza, How do you manage RLS without O365?

@RADACAD 5 жыл бұрын

Power BI accounts are O365 accounts anyways. What do you mean by RLS without O365? if you mean Report Server, then same principal works with Domain accounts in PBIRS

@Fernando_Calero 5 жыл бұрын

@@RADACAD If the company runs its email service with a different provider, for instance with the gmail platform. Shall I have to duplicate the organization hierarchy from their email platform to O365 maybe in order to be able to deliver RLS within PBI?

@humerashaikh3618 2 жыл бұрын

how can i download dataset ?

@TehsimShaikh 2 жыл бұрын

I followed the same instructions and in power bi desktop it shows me in view as it works fine. In dataset setting i have given the permission to 1 user to a filter. But that users can see everything. Why ?

@RADACAD 2 жыл бұрын

how did you give permission to the user? if the user has edit access on the report then he/she would see everything. example of edit access is if they have Contributor, Member, or administrator rights on the workspace in which the dataset is published.

@TehsimShaikh 2 жыл бұрын

@@RADACAD Thank You so much for your message, I created a new Workspace and that user is Member only. I am getting my data from Microsoft EPM and that user does not have the access to that environment. In my report i have values for example Sector where there are 10 sectors and from the publish dataset i assigned 1 user to 3 sector. So he should see only 3 sector values, but he can see all the sector values. As a workspace access he can only access the workspace as a member.