What is Object-Level Security (OLS) in Power BI? | RLS Vs OLS in Power BI | Power BI

[@BIConsultingPro]

To download Power BI File used in this video, kindly find the following link: 1drv.ms/u/s!ApIf9f9Q3qOxkyCj6E8suJza_WfZ?e=Baqpp0

[@braxtonmakai5366]

i realize it is pretty randomly asking but does anyone know of a good site to stream new movies online ?

[@garrettlachlan4380]

@Braxton Makai i dunno try flixportal. you can find it thru google:) -garrett

[@braxtonmakai5366]

@Garrett Lachlan Thank you, I signed up and it seems like a nice service =) Appreciate it!!

[@garrettlachlan4380]

@Braxton Makai No problem :D

[@RohitSingh-zs1ui]

Hello @BI Consulting Pro, What Keyboard and mouse combo did you use at 3:07 to replicate the card in Report tab?

[@v.s.5460]

If I have a visual with more than one measures and only one of those measures uses a column with OLS is this going to break the visual once a user who doesn't have permission to see that column opens the page? If no, how is it visualized?

[@BIConsultingPro]

I think so, however, honestly speaking I haven't tried it out. Why don't you try and share your experience? If you face any issues, kindly let us know

[@dp6736]

Thank you very much for the great tutorials,

[@ashishmohan4707]

Hi Ajay Sir, Nice explanation, Thanks for coming with new topic, In RLS it directly opened without email enter Thanks to share this imp. concept with us

[@BIConsultingPro]

Could you please elaborate it a bit more " In RLS it directly opened without email enter"?

[@ameyraj4947]

Very well explained. Thanks for sharing🎉🎉

[@BIConsultingPro]

Thank you

[@sravankumar1767]

Nice explanation, Thanks for coming with new topic, In RLS it directly opened without email enter

[@BIConsultingPro]

You can test either role or via e-mail address

[@prashantvarun23]

thank you so much very well explanation

[@Sureshpal-mj5bf]

Hi , Do we have any feature to customise that error message in tabular editor something like "You are not allowed to see this visual". The default error message seems there is some issue with the report. Please let me know if we have any option for this. Also Can we applied security from a single table to all the workspaces?

[@BIConsultingPro]

We haven't tried it. Let us work over it, and if we find something, we'll create a video.

[@pradeepkumarpotnuru2856]

How do we implement the same with Dynamic RLS

[@BIConsultingPro]

Hi Mr. Kumar, we already have a dedicated series on RLS. Please watch this here: kzbin.info/aero/PLp4MAoTwZIfc9zn1G3U8jhe9BVFOzWZ7_ I hope this will help you :) Good luck!

[@annaabraham4368]

I haven't installed tabular editor.could you please let me know whether tabular editor is required or not. What is the use of tabular editor other than in ols

[@walterwego1396]

Nice. Thanks for the tutorial

[@BIConsultingPro]

Thank you

[@Laxmanmane007]

Hi Ajay small Question suppose I created role for specific country and that role don't need to click other countries visual like button if we have then what will be the best solution for that(is there any option for visual security ).

[@BIConsultingPro]

I think on that case you can use static RLS.

[@debasreetripathy5962]

This was really nedded🙏🙏🙏

[@BIConsultingPro]

Thank you! You guys can request any video in future!

[@raviranjansingh5527]

Great sir

[@BIConsultingPro]

Thank you

[@the12208]

Hi Very good explanation with the demo, but I have a doubt after publishing the report into a workspace when I open the report I want to see only the records related to me by default how to achieve that? Each time I need to go to the security in the dataset to test via role to see the records only related to me. How to make that option by default in powerbi service to show only the records related to that particular user.

[@BIConsultingPro]

If you have implemented Dynamic RLS, you would see what you are entitled for. You don't need to do any extra efforts.

[@vamsikrishna254]

Fabulous... kudos

[@yeswanthdogiparthy38]

Hi Very good explanation with demo, but i have doubt after publishing the report into a workspace and assigning the users to workspace as viewers this will work fine but what need to be done if a user is changed from viewer to member for the same workspace he also should have same security restrictions on the data is this possible . Thanks in advance !

[@BIConsultingPro]

Well, of course, this would impact. A Power BI workspace member has almost same power as of a Power BI Admin. So, definitely these won't apply for him. He/She can view, edit or delete reports. However, viewer role is just for the report consumption where RLS/OLS comes into the picture. For more information, please check this link: docs.microsoft.com/en-us/power-bi/collaborate-share/service-new-workspaces

[@srimissram]

I'm new to this Power BI, learning through your videos. A big thanks for that. I have a doubt how to assigne those roles to users or groups?

[@BIConsultingPro]

Thanks for your humble words! You can assign using security settings in your datasets like you do in RLS. For more info, check this link: docs.microsoft.com/en-us/power-bi/admin/service-admin-rls Please check under "Manage security on your model"

[@shantanujoshi4129]

Just a question, if I use sales, finance revenue fields in table and apply OLS on finance number, would that not break the complete table view?

[@BIConsultingPro]

This won't break it. OLS is object level security that means you can apply this to either a table or a field. However, I'll advise you to try this first at your end, and see yourself the results.

[@hajaaa100]

Instead of showing some error on the visual. can hide the visual or show some neat message in label over the visual

[@BIConsultingPro]

You can do this but that would be a complex DAX Expression.

[@bagpipe2411]

can OLS be applied on measures directly?

[@BIConsultingPro]

Object-level Security hides tables, columns, and measures but also secures them. Your secured tables and columns are obscured in the field list when using reporting tools like Excel or Power BI. As per the definition, yes you can but if you are trying to directly write the DAX expression, then I am afraid to say NO.

[@bertroos60]

Thanks for this video! But why the music? .... makes it very hard to concentrate

[@BIConsultingPro]

Thanks, Bert for the feedback. I can understand your problem. However, no matter how sorry I am, this video cannot be edited now. Moreover, I am not including any music my videos nowadays. I hope you would like all the current and the future videos. I am looking forward for your feedback on my other videos.

[@databaz1]

So good 😊

[@rahulachapale3393]

Stop ads

[@BIConsultingPro]

Thanks for your feedback! As I have mentioned previously, if you don't want ads, kindly get our channel membership. Thanks once again for watching the video.

[@aditrupani2319]

very bad voice quality some words are not untestable.

[@BIConsultingPro]

thanks, Adit for your feedback. We have worked on our video and audio qualities. I hope you would find it better in our latest videos.